topic Re: How to create yesterday date in DD/MM/YY format in script? in QlikView

How to create yesterday date in DD/MM/YY format in script?

Mon, 01 Apr 2013 13:48:06 GMT

Hi,

Please help me out on 'To create yesterday date in DD/MM/YY format in script'

I used the below code

LET vMonthDate =Date(Num(Today()-1),'DD/MM/YYYY');

But its giving me the date in string format, I need that in date format to override the date in designer.

Thanks...

Re: How to create yesterday date in DD/MM/YY format in script?

manideep78 — Mon, 01 Apr 2013 13:50:00 GMT

LET vLastDate = Date(Today()-1,'DD/MM/YYYY')

Re: How to create yesterday date in DD/MM/YY format in script?

CELAMBARASAN — Mon, 01 Apr 2013 13:55:11 GMT

Can you explain your problem little more?

Moreover below will helps

LET vMonthDate = Date(Num(Today()-1))

Re: How to create yesterday date in DD/MM/YY format in script?

Mon, 01 Apr 2013 13:55:42 GMT

It's giving me in the string format only, not in date format. So I could not change/override in the GUI fot that field.

Re: How to create yesterday date in DD/MM/YY format in script?

manideep78 — Mon, 01 Apr 2013 14:03:05 GMT

It must get in Date format not in string format. If not please elaborate your problem little more in explanation.

Re: How to create yesterday date in DD/MM/YY format in script?

jagan — Mon, 01 Apr 2013 14:07:59 GMT

Hi,

This is working for me, when I reload the QVW file I am able to see Yesterday's date 31/03/13.

LET vMonthDate =Date(Today()-1,'DD/MM/YY');

Regards,

Jagan.

Re: How to create yesterday date in DD/MM/YY format in script?

Mon, 01 Apr 2013 14:12:08 GMT

I want to save the yesterday's date in qvd...

LET vMonthDate =Today()-1;

Temp:

LOAD Date('$(vMonthDate)','DD/MM/YY') as Month_Date

FROM Data.xlsx (ooxml, embedded labels, table is Sheet1);

STORE Temp into Data.qvd(qvd);

Finally I achieved that by using the above code

Thankq...

Re: How to create yesterday date in DD/MM/YY format in script?

jagan — Mon, 01 Apr 2013 14:56:12 GMT

Hi,

I think this is most efficient one, no need of variable

Temp:

LOAD

Date(Today() - 1,'DD/MM/YY') as Month_Date

Autogenerate 1;

STORE Temp into Data.qvd(qvd);

DROP TABLE Temp;

Hope this helps you.

Regards,

jagan.