Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have to create a variables for start date and end date for max month in a table, and last year same month start date and date.
Ex: I have table with 01-01-2017 to 31-03-2018. i have to create the variables for fetch the data from 01-03-2018 to 31-03-2018 and 01-03-2017 and 31-03-2017. (Compare current month and last year same month)
One variable can have only one value. So if you want four different values then you need four different variables:
vStartDateCurrentYear: =MonthStart(Max(MyDateField))
vEndDateCurrentYear: =MonthEnd(Max(MyDateField))
vStartDateLastYear: =MonthStart(Max(MyDateField),-12)
vEndDateLastYear: =MonthEnd(Max(MyDateField),-12)