Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
can somebody help me in calculating the last monday of a given month?
Thx in advance!
-Phil
=Weekstart(MonthEnd( Makedate(YourYearField, YourMonthField) ))
Hi Philipp,
date((WeekStart(yourDate) ), 'D-M-YY') AS FirstDayWeek
Best regards,
Andrés
=Weekstart(MonthEnd( Makedate(YourYearField, YourMonthField) ))
Thank you!
You Guys are awesome .
Hi Philipp,
This is it
=Date(WeekStart(MonthEnd(date#('03/09/1993','MM/DD/YYYY'),0)),'DD/MM/YYYY')
in the date given you can give your field also