Date converstion help to DD/MM/YYYY Format - Qlik Community

mahitham · ‎2018-11-22

Hi Experts,

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

I have used below script but last 4 date formats which are in DD/MM/YY are not converted. Please help me on this.

Thanks in advance

kaushiknsolanki · ‎2018-11-22

Hi,

It seems like the last 4 values has the space at start.

Try removing the space by Trim function.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

mahitham · ‎2018-11-22

Hi Kaushik,

Thanks for your reply.

I have tried like below with trim function but still getting the same result.

kaushiknsolanki · ‎2018-11-22

Use Trim function for all "StartDate" and check.

If doesnt work share the sample data.

Regards,

Kaushik Solanki

Please remember to hit the 'Like' button and for helpful answers and resolutions, click on the 'Accept As Solution' button. Cheers!

Anil_Babu_Samineni · ‎2018-11-22

Try to remove Left part like Date and Num and check what it is returning?

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