Skip to main content
Announcements
Qlik Community Office Hours, March 20th. Former Talend Community users, ask your questions live. SIGN UP
cancel
Showing results for 
Search instead for 
Did you mean: 
mahitham
Creator II
Creator II

Date converstion help to DD/MM/YYYY Format

Hi Experts,

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

start date.png

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

start date script.png

 

Thanks in advance

 

 

4 Replies
kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator II
Creator II
Author

Hi Kaushik,

Thanks for your reply.

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

start date script.png

kaushiknsolanki
Partner Ambassador/MVP
Partner Ambassador/MVP

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

Try to remove Left part like Date and Num and check what it is returning?
Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)