Hi,
I am filtering data in query by Months. My date field name is "OrderDate".
I am able to filter the data in Month (with Month Name).
I used the following code
in this code "mmmm" gives me full name of month, and "yyyyy" gives me full year
this code I am using in Query "Field"
as picture below.
and I get the result as below picture
I have one problem and One question.
1) Months are not sorted by Latest month 1st and so on ------- rather they can only be sorted alphabetically
2) My main question is How can I get result of last two months only.
Thank you
I am filtering data in query by Months. My date field name is "OrderDate".
I am able to filter the data in Month (with Month Name).
I used the following code
Code:
Month: Format([OrderDate],"mmmm\,yyyy")
in this code "mmmm" gives me full name of month, and "yyyyy" gives me full year
this code I am using in Query "Field"
as picture below.
and I get the result as below picture
I have one problem and One question.
1) Months are not sorted by Latest month 1st and so on ------- rather they can only be sorted alphabetically
2) My main question is How can I get result of last two months only.
Thank you