Case 907 How to recode date file to dd/mm/yyyy ?

[paulyeo11]

Hi All

My CSV raw data as below :-

My load script as below :-

Directory;
LOAD [Closing Date]
FROM
..\..\..\Dropbox\QV_RAW_ISDN\CRM_TS_.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

After read into Qlik view , i use the list field name i get below :-

Apr 30, 2020
Aug 31, 2020
Feb 29, 2020
Mar 31, 2020

May i know , how to Recode the [Closing Date] field to dd/mm/yyyy ?

Paul Yeo 

[martinpohl]

change to

date(date#([Closing Date],'MMM DD,YYYY'),'DD/MM/YYYY') as [Closing Date]

regards

date# = the input format

date = the output format

[paulyeo11]

Dear Sir

I just try and it does not work. 

Enclosed my sample data.

Paul

[tresesco · Accepted solution]

Your date values have one space between comma and year. Hence you have to adjust the formatting in date#() accordingly, like:

date(date#([Closing Date],'MMM DD, YYYY'),'DD/MM/YYYY') 

[paulyeo11]

Hi Tresesco

Thank you for your sharing , it work fine now. Your name sound very familiar t me , May be you have change the profile photo.

Paul Yeo

[tresesco]

Yes Paul, you are right I have changed my profile pic. 

I have also happened to reply and resolve some of your queries earlier. Also, you and me both are here in this community for long now. 🙂