Forum Discussion

amit_saroha's avatar
amit_saroha
New Contributor III
4 years ago

Date format problem

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 d...
darshthakkar's avatar
darshthakkar
Valued Contributor
4 years ago
Copy LinkReport

@amit.saroha: Are you expecting the format yyyy/MM/dd HH:mm:ss for Null values?

  • del's avatar
    del
    Contributor III
    4 years ago
    Copy Link

    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.