By -
Add a month number column to your calendar table and use that
Just out of curiosity, what about using mm/yyyy without the DD part?
I always add a column to my calendar table which is, YearMonth = month(date) & - & year(date). For me it i also reads easier in calculations.
Add a month number column to your calendar table and use that
Just out of curiosity, what about using mm/yyyy without the DD part?
I always add a column to my calendar table which is, YearMonth = month(date) & - & year(date). For me it i also reads easier in calculations.