How to write the Date Expressions with the Offset -1 for day/Month

[Anonymous]

The data displayed on the report have an offset of -1, ie, on April 19th, the data is as of April 18th.

Need to  offset the day by ‘-1’.

When the report is opened, the month filter should be on March not on April. You need to  offset the day by ‘-1’

By using this variable able to display the Previous day.

How to write in if else conditional statement if(April-1)->March

LET vRefreshDate = Today()-1;

[sunny_talwar · Accepted solution]

Yes that is what it will give you.

vRefreshMonth = Month(Today() - 1)

vRefreshDate = Date(Today() - 1)