Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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..
Hi,
If you want output in MMM YY format
Then write
Date(AddMonths(Date#(YourField,'MMM YY'),-11),'MMM YY')
Regards
Hi,
Try this
AddMonths(Date#(YourField,'MMM YY'),-11)
or
use AddYears(Date#(YourField,'MMM YY'),-1)
Regards
Hi,
If you want output in MMM YY format
Then write
Date(AddMonths(Date#(YourField,'MMM YY'),-11),'MMM YY')
Regards
Thanks mate..it works..
Hi Vimal;
Try:
=Date(Addmonths(date#([Your field]),-11),'MMM YY')
Regards
KC