Harsha3
6 years agoNew Contributor III
Date conversion
Hi ,
I am having a source csv file which contains the date in the format dd-MON-yyyy ( say for example 01-JAN-2020 ) . I need to convert this data format to the form yyyy-mm-dd ( say 2020-01-01 ) . I have tried using various methods to parse the date but could not achieve the conversion . So I have used the conditional mapping here and the code gets bigger as I need to incorporate 12 months and hard code the values . Please refer below
$Review_Date.split(‘-’)[2]+‘-’+$Review_Date.split(‘-’)[1]==‘Jan’?‘01’:($Review_Date.split(‘-’)[1]==‘Feb’?‘02’:‘00’)+‘-’+$Review_Date.split(‘-’)[0]……
Is there any optimised way in achieving the above scenario .