Last Day of Last Month

[Former Member]

Hi,

In my report we need to make some calculation based on last day of last month. ie) for today (7th Jan 2014) we need to derive the value 31st Dec 2013.

Please help me to derive this.

Thanks,

Parthi.

[Former Member · Accepted solution]

Hi,

=ToDate(RelativeDate(CurrentDate();-Daynumberofmonth(CurrentDate()));"dd/MM/yyyy")

Here Current Date is today date.

this formula will help to derive the last day of last month.

Thanks,

Sakthi.

[Former Member]

Try using

=LastDayOfMonth(RelativeDate(CurrentDate();-(DayNumberOfMonth(CurrentDate())+1)))

[rushikesh97]

How to create same formula in IDT ? As the relative date functions are not available in IDT.