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 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”})

3 Replies

  • 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 LinkReport

        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.