topic Case 933 How to recode date with Month in word ? in QlikView

Case 933 How to recode date with Month in word ?

paulyeo11 — Fri, 18 Sep 2020 06:44:41 GMT

Hi All

My raw data :-

SeriesName	DocDate
SME	30-Apr-20
SME	24-Aug-20
SME	31-Aug-20
SFA	12-Aug-20

Directory;
LOAD
DocDate

FROM
QUOT_SD_.csv
(txt, codepage is 1252, embedded labels, delimiter is ',', msq);

Can some one advise how to recode the date ? So the date recognize by the calendar .

Paul Yeo

Re: Case 933 How to recode date with Month in word ?

Taoufiq_Zarra — Fri, 18 Sep 2020 07:56:46 GMT

@paulyeo11 like ?

Date#(DocDate,'DD-MMM-YY') as DocDate

Re: Case 933 How to recode date with Month in word ?

Kushal_Chawda — Fri, 18 Sep 2020 09:30:07 GMT

@paulyeo11 If all your Date field format is same then better to set below date format variable in main tab. So that if you load the it will be automatically converted to date format.

SET DateFormat='DD-MMM-YY';