topic Re: MTD variable in QlikView

MTD variable

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

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 — Mon, 29 Aug 2016 06:31:35 GMT

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 — Mon, 29 Aug 2016 06:33:25 GMT

Oh am sorry..

The above isn't right..

Please check it once..

Thanks...

nareshthavidishetty — Mon, 29 Aug 2016 06:53:42 GMT

Hi,

Got it..

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

Thanks,,

tamilarasu — Mon, 29 Aug 2016 07:01:17 GMT

Hi Naresh,

Try this,

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

nareshthavidishetty — Mon, 29 Aug 2016 07:12:45 GMT

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

tamilarasu — Mon, 29 Aug 2016 07:16:41 GMT

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