Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
how below expression works? can anyone explain?
Num(if(month(today())>=2,date('06/02/'&year(today()),'dd/mm/yyyy'),date('06/02/'&year(today())-1,'dd/mm/yyyy')))
Thanks
Sony
Which month end? What is the logic?
An easier way to get month end date is to calculate the first day of (month+1), and then subtract 1.
And what about the MonthEnd() function?
:
LET vMonthEnd = Date(Floor(MonthEnd(Today())), 'DD/MM/YYYY'); // Date part only
:
Best,
Peter