My Table appear 2 Column of May 2013 ?

[#1]

Hi All

I use below expression for label :-

May 2013 label :-

=Date(today()-90,'MMM YY')

April 2013 label :-

=Date(today()-120,'MMM YY')

Mu issue is the both above expression , it display May 2013 ?

Paul

[jagan · Accepted solution]

  Hi,

Try like this

For Apr-2013

=Date(AddMonths(today(), -4),'MMM YY')

For May-2013 

=Date(AddMonths(today(), -3),'MMM YY')

Regards,

Jagan.

[#3]

Hi Jagan

Your approach work fine. But i am very surprise , where go wrong ? I believe there are reasons for it. 

Any way thank you very much for your advise.

Paul