Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello everyone,
how to get last date of the month?
Thanks
Use MonthEnd() function
May be like this:
Date(Floor(MonthEnd(Today())))
Replace Today() with whichever date's last date of the month you are looking to get
Re: create last day of a month
chk abve
Which month? And which date, the last existing date for that month that exists in your data or the one that's the last day of the month?
is dis correct ??
Date(MonthEnd(( ModifiedDate)), 'DD/MM/YYYY') as lastdate;
I would add a Floor in there as well because MonthEnd gives a timestamp something like this -> 05/31/2016 23:59:59
Date(Floor(MonthEnd(ModifiedDate)), 'DD/MM/YYYY') as lastdate;
i have one more requirement ie.
need last date of fiels named as Handover date and Takeover date.
How do i do that?
Same logic for all the fields I guess
Date(Floor(MonthEnd([Handover date])), 'DD/MM/YYYY') as lastdate_Handover,
Date(Floor(MonthEnd([Takeover date])), 'DD/MM/YYYY') as lastdate_Takeover;
Thanks Sunny T