how to substract month from date

[#1]

Hi All,

I have a date field. I need to show records of last n months. So here I need to subtract given months from current date so that I'll get the date from where I need to display the records..

There is a function called AddMonths but I couldn't find such method for Substracting months. Can anybody plz guide me in subtracting given months from date?

[jagan · Accepted solution]

Hi,

If you give months in -ve then it will subtract, check below example

=AddMonths(Today(), 1)  -- 1/5/2014

=AddMonths(Today(), -1)  -- 11/5/2013

Hope this helps you.

Regards,

Jagan.

[#3]

Thanku