How to convert date into DD/MM/YYYY Format

[mahitham]

Hi Experts,

Can any one please help me to convert the User_StartDate  field into DD/MM/YYYY Format.

I have tried the below script but last 4 dates which are highlighted in red color was not converted into DD/MM/YYYY format. Please help me on this.

Thanks in advance

[Anil_Babu_Samineni]

Bump

https://community.qlik.com/t5/New-to-Qlik-Sense/Date-converstion-help-to-DD-MM-YYYY-Format/m-p/15108...

[Zhandos_Shotan]

Hi!

Try to use something like:

if(Len(Trim(User_StartDate  ))=8,  [...alt...Date#(StartDate,'DD/MM/YY')...] ,

    if(Len(Trim(User_StartDate  ))=10, [...alt...Date#(StartDate,'DD/MM/YYYY')...] )

)

[jonathandienst]

Your expression looks correct* so perhaps the problem dates contain hidden characters or white space. Perhaps you could upload a sample text file containing the problem dates (and 'good' dates).

*Your expression does not require the outer Date(Num ....)). This is redundant and will do nothing.