Month's Last Day in number

[#1]

Please Help?? If i hav 1 field named 'Inv.date'. e.g the value in the filed is 12 Nov 2009 or 12.11.2009.

Now i wanted to find the last date of the month i.e 30.

what should i do????

[#2]

MonthsEnd(Inv.date) as "End of month Inv" should do the trick.

Rgds,

Sébastien

[#3]

And If you want the day, Day(MonthsEnd(Inv.Date)) as "xxxxx"

[Anonymous · Accepted solution]

Create one more field with formula

MonthEnd(Date([Inv.date])) as MonthLastDay;

Rgds,
Artjoms Tukums