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????
MonthsEnd(Inv.date) as "End of month Inv" should do the trick.
And If you want the day, Day(MonthsEnd(Inv.Date)) as "xxxxx"
Create one more field with formula
MonthEnd(Date([Inv.date])) as MonthLastDay;
Retrieving data ...