โ06-15-2022 06:32 AM
Hi,
I have a CSV file containing the dates like โ16-DEC-2019โ and I am reading the CSV file and inserting it into an Oracle database table but it always errors out because the format desired is a date in format yyyy/mm/dd hh:mi:ss.
I have used the below expression but it returns NULL as well. Can you please help me how to get it corrected?
Date.parse($[โDate Fromโ]!= null ? $[โDate Fromโ].toString().substr(0,10) : $[โDate Fromโ]).toLocaleDateString({โformatโ:โyyyy/MM/dd HH:mm:ssโ})
โ06-15-2022 06:52 AM
@amit.saroha: Are you expecting the format yyyy/MM/dd HH:mm:ss
for Null values?
โ06-15-2022 06:53 AM
no, they can be null.
โ06-15-2022 10:37 AM
Thereโs probably a number of ways to write this out, but try this expression:
$['Date From'] != "" ? Date.parse($['Date From'],'dd-MMM-yyyy').toLocaleDateString({"format":"yyyy/MM/dd HH:mm:ss"}) : null
It may still need to be tweaked for your use case.