Skip to Content
0
Jun 02, 2020 at 05:28 AM

How to get Current Month, Previous Month and Last Year Current Month date based on country column

120 Views

Hi All,

I have a requirement like i want to show current month(June 2020) , previous month(May 2020) and last year current month(June 2019), YTD, In report end i have one prompt it will be showing current month always.

In the attachment you can see i have taken count of each country. I tried Previous function but this function works only when i have month column in the report but we dont want to use month column in this report even though i have in the database. I am stuck with this. Please let me know how can i solve.

Attachments

image.png (28.1 kB)