Format week

[smilingjohn]

Hi All , 

Please find the attachment of the QVW file , 

I want to show the weekeknd format like DD-MMM-YY  ( 28-Jul-20)  I tried conevrting it in the calendare in load script but still this doesnot change . Please suggest me . 

[zhadrakas · Accepted solution]

try to change the default variables or comment them out

SET TimeFormat='h:mm:ss TT';
SET DateFormat='M/D/YYYY';
SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT';

regards 

[Taoufiq_Zarra]

if I understood correctly

Date(Weekend,'DD-MMM-YY')

attached qlik file

output :

[smilingjohn]

Hi 

You have changed the format of weekend within the listbix edit mode . 

But i want the same format in the Load script . WHich I am strugling to do it 

[Kushal_Chawda]

try change below script. 

Test:
LOAD
Date(Date#(Created),'DD-MMM-YYYY') as Created,
//Date(Created,'MM/DD/YYYY') as Date1,
Date(Date#(Created),'DD-MMM-YYYY') as Date

FROM
[C:\STestWeekend]
(qvd);

You can now simple change the format using Date function on Calendar