Solved: Date conversion into DD/MM/YYYY Format - Qlik Community

mahitham · ‎2020-01-20

Hi,

Can any one please help me to convert below date into DD/MM/YYYY format.

Thanks in advance.

Anil_Babu_Samineni · ‎2020-01-20

May be

Date(alt(Date#(Date, 'DD/MM/YYYY'), Num#(Date)), 'DD/MM/YYYY')

Best Anil, When applicable please mark the correct/appropriate replies as "solution" (you can mark up to 3 "solutions". Please LIKE threads if the provided solution is helpful

View solution in original post

Kushal_Chawda · ‎2020-01-20

try

LOAD *,

alt(date(Date#(DateField,'DD/MM/YYYY'),'DD/MM/YYYY'),date(DateField,'DD/MM/YYYY')) as DateFinal

FROM YourQVD;