QS-last date of the month

[Karahs]

hello everyone,

          how to get last date of the month?

Thanks

[alexandros17]

Use MonthEnd() function

[sunny_talwar]

May be like this:

Date(Floor(MonthEnd(Today())))

Replace Today() with whichever date's last date of the month you are looking to get

[Chanty4u]

Re: create last day of a month

chk abve

[Gysbert_Wassenaar]

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?

[Karahs]

is dis correct ??

Date(MonthEnd(( ModifiedDate)), 'DD/MM/YYYY') as lastdate;

[sunny_talwar]

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;

[Karahs]

i have one more requirement ie.

need last date of fiels named as Handover date and Takeover date.

How  do i do that?

[sunny_talwar]

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;

[Karahs]

Thanks Sunny T