Date conversion into DD/MM/YYYY Format

[mahitham]

Hi,

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

Thanks in advance.

[Anil_Babu_Samineni · Accepted solution]

May be

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

[Kushal_Chawda · Accepted solution]

try

LOAD *,

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

FROM YourQVD;