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

[#1]

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...

[manideep78]

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

[CELAMBARASAN]

Can you explain your problem little more?

Moreover below will helps

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

[#4]

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.

[manideep78]

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

[jagan]

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.

[#7]

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...

[jagan]

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.