Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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????
Create one more field with formula
MonthEnd(Date([Inv.date])) as MonthLastDay;
Rgds,
Artjoms Tukums
MonthsEnd(Inv.date) as "End of month Inv" should do the trick.
Rgds,
Sébastien
And If you want the day, Day(MonthsEnd(Inv.Date)) as "xxxxx"
Create one more field with formula
MonthEnd(Date([Inv.date])) as MonthLastDay;
Rgds,
Artjoms Tukums