Date Format Help

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

Hi Experts,

Can any one please help me to convert the below multiple date formats into DD-MM-YYYY Format.

I have tried like below but all are getting in DD/MM/YYYY format when i have changed DD-MM-YYYY also its showing DD/MM/YYYY only.

Date(alt(SalesDate,Date#(SalesDate,'DD-MM-YYYY'),Date#(SalesDate,'DD/MM/YYYY'),Date#(SalesDate,'DD.MM.YYYY'),'DD-MM-YYYY')) AS [Date]

Calender:
Load *,
Date(alt(SalesDate,Date#(SalesDate,'DD-MM-YYYY'),Date#(SalesDate,'DD/MM/YYYY'),Date#(SalesDate,'DD.MM.YYYY'),'DD/MM/YYYY')) AS [Date]

Inline [
SalesDate,Sales
01-02-2015,100
02/03/2016,200
03.04.2017,300

];

Please help me on this.

Thanks in advance.

Re: Date Format Help

tresB — Wed, 05 Dec 2018 05:48:24 GMT

Try this:

Calender:
Load *,
Date(alt(SalesDate,Date#(SalesDate,'DD-MM-YYYY'),Date#(SalesDate,'DD/MM/YYYY'),
Date#(SalesDate,'DD.MM.YYYY')),'DD-MM-YYYY') AS [Date]

Inline [
SalesDate,Sales
01-02-2015,100
02/03/2016,200
03.04.2017,300

];

topic Date Format Help in QlikView

Date Format Help

Re: Date Format Help