Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Multiple Dates Using Alt

Chanty4u
Esteemed Contributor III

Multiple Dates Using Alt

Hi All,

Having multiple date formats in single Date field.

Below is one sample with different date formats in single field.

Date:

load *,

date(alt( date#( Mydate , 'DD-MM-YYYY' ),

timestamp#( Mydate , 'DD-MM-YYYY hh:mm:ss' ),

date#(Mydate,'DD MMM YYYY'),

date(Mydate,'DD-MMM'),

date#( Mydate , 'DD/MM/YYYY' )),'DD.MMM.YYYY hh:mm:ss TT' ) as NewDate;

LOAD * Inline [

Mydate,sales

23-10-2018,100

20/11/2018,200

15-12-2018 12:13:47,300

18 jul 2018,400

];

EXIT SCRIPT;

Result:

alt.PNG

Tags (3)
Comments
YoussefBelloum
Esteemed Contributor

interesting, thanks for sharing

Chanty4u
Esteemed Contributor III

Thanks Youssef

Version history
Revision #:
1 of 1
Last update:
‎2018-06-12 05:32 AM
Updated by: