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;
If I' Using the vToday() then above things will work.I have a Column with Cal_Year.
By max(Cal_Taer) i can get the max-Month,date but how to put in the if else logic if(vday=1,vmonth=May,vday=31,vMonth=April)-Actually i'm trying in this way but no luck.Expecting solution as stated.
Sorry,I didn't explained in good way.I kept the expression for Understandable.
I'm expecting in dynamic way if every month start it should take the prior month last date.
Expecting in the multi conditional statement in a Text Object.
How can the above Scenario can be achieved?
On Open of the Document need to get the Year,Month.
Attached the sample,implemented the Triggers .
My Question is the Variable "vRefreshMonth = Month(Today() - 1)"
,will always give the expect result like below or is there any other way to achieve this
|Refresh Date||Expected Date||Expected Month|