Create a variable for max month start date and end date

[Kohli]

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)

[Gysbert_Wassenaar]

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)