How it works?

[soniasweety]

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

[tresB]

Which month end? What is the logic?

[Ben_P]

An easier way to get month end date is to calculate the first day of (month+1), and then subtract 1.

[Peter_Cammaert]

And what about the MonthEnd() function?

:

LET vMonthEnd = Date(Floor(MonthEnd(Today())), 'DD/MM/YYYY'); // Date part only

:

Best,

Peter