Getting Previous Year as text

[#1]

Hi,

I am selecting a month (ex- Sep 13) from list box. I have text box where in I want to display Oct 12 as output.

Any idea how to do that.

I tried with the following

=

date(num(Month-365),'MMM-YY')

But, it doesnt work. It throws Sep 12. Here Month is a field in table having values like May 13, June 13 etc..

[PrashantSangle]

Hi,

Try this

AddMonths(Date#(YourField,'MMM YY'),-11)

or

use AddYears(Date#(YourField,'MMM YY'),-1)

Regards

[PrashantSangle · Accepted solution]

Hi,

If you want output in MMM YY format

Then write

Date(AddMonths(Date#(YourField,'MMM YY'),-11),'MMM YY')

Regards

[#4]

Thanks mate..it works..

[jyothish8807]

Hi Vimal;

Try:

=Date(Addmonths(date#([Your field]),-11),'MMM YY')

Regards

KC