Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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...
LET vLastDate = Date(Today()-1,'DD/MM/YYYY')
Can you explain your problem little more?
Moreover below will helps
LET vMonthDate = Date(Num(Today()-1))
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.
It must get in Date format not in string format. If not please elaborate your problem little more in explanation.
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.
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...
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.