Comparing data from current to previous years

[jsbarroso]

CJ_London, The PYMonth and CYMonth fields are formatted as Format$([Usage Ending Date],"mmmm"). When create a report I am unable to sort the months based on a date. Is there a way I can add the month number to each or as a seperate field?

 

[CJ_London]

yes - the function is month(myDate)

 

[jsbarroso]

CJ_London,

I also just solved it by using MonthNo: Month(DateValue([Month] & " 1")). Thank you for your recommendation.