topic Re: Case 907 How to recode date file to dd/mm/yyyy ? in QlikView

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

paulyeo11 — Tue, 11 Aug 2020 08:43:32 GMT

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 — Tue, 11 Aug 2020 09:08:37 GMT

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 — Wed, 12 Aug 2020 04:20:33 GMT

Dear Sir

I just try and it does not work.

Enclosed my sample data.

Paul

tresB — Wed, 12 Aug 2020 05:34:21 GMT

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 — Wed, 12 Aug 2020 05:40:16 GMT

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

tresB — Wed, 12 Aug 2020 06:00:15 GMT

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. 🙂