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.