Case 933 How to recode date with Month in word ?

[paulyeo11]

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

[Taoufiq_Zarra · Accepted solution]

@paulyeo11 like ?

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

[Kushal_Chawda · Accepted solution]

@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';