variable

[master_student]

Hello

I need to create a variable that retunrs the month -1 of today in that format yyyymm (201702)

LET vDate2 = date(Today(), 'YYYYMM') // this variable returns the current month and I need current month -1

Thanks

[sunny_talwar · Accepted solution]

May be this

=Date(MonthStart(Today(), -1), 'YYYYMM')

[master_student]

Thanks Sunny for your help