Dates Falling in last 3 months

[stuwannop]

Hi Everyone

Hope you can help me with a bit of script.

I currently have a line in my calendar script that that will return a 1 if the date loaded falls in the last calendar month. The line is:

IF(InMonthToDate(Date, today(), -1),1,0)

I am trying now to write the same script line but this time to return a 1 if the date falls in the last THREE calendar month - not including the current month.

I've played around with multiple if but I can't quite crack it - can anyone help?

Thanks

Stu

[daveamz · Accepted solution]

Hi Stu,

Try

If(Date>=MonthStart(AddMonths(Today(),-3)) AND Date<MonthStart(Today()),1,0) as InLast3Months

Best regards,

David

[stuwannop]

That's superb David - thanks for your help and the quick response.

Stu