MTD variable

[nareshthavidishetty]

Hi,

The below variable gives '1160801' which is century format and actual date is '08/01/2016'.

But i need the below variable which gives the date '1160828'  wchi means '08/28/2016'.

Let CurrentyearYesterday=1&date(date(monthstart(today()),'MM/DD/YYYY'),'YYMMDD');

Thanks..

[nareshthavidishetty]

Hi,

Got it i forget there is an monthstart in the variable replacing monthstart with month fixed the issue.

Let CurrentyearYesterday=1&date(date(month(today()-1),'MM/DD/YYYY'),'YYMMDD');

Thanks..

[nareshthavidishetty]

Oh am sorry..

The above isn't right..

Please check it once..

Thanks...

[nareshthavidishetty · Accepted solution]

Hi,

Got it..

Let CurrentyearYesterday=1&date(date((today())-1,'MM/DD/YYYY'),'YYMMDD');

Thanks,,

[tamilarasu]

Hi Naresh,

Try this,

Let CurrentyearYesterday =(Year((Today()))-1900) & Num(Month(Today()),'00') & Num(Day(Today()-1),'00') ;

[nareshthavidishetty]

Thanks... Nagraj for response and the issue is resolved as per the previous post..

[tamilarasu]

I'm a bit late. Just thought to share my idea.