I have a table which contains a series of dates. I need some help to get the month number of the date, this month number is determined by the range that is selected - not the month number in the year. I've attached 3 examples to illustrate what i mean.
the table is called t_test, the date column is called dte. month_no is the column that i need some assistance with. Any help is appreciated.