Forum Discussion

Harsha3's avatar
Harsha3
New Contributor III
6 years ago

Date formatting

Hi , I am trying to convert a local-date-time format to dd-MMM-yy ( say for eg :13-NOV-19). I tried various methods still could not achieve this . It could be useful if I have a method to achieve...
alchemiz's avatar
alchemiz
Contributor III
4 years ago
Copy LinkReport

Hi Mellisa,

Good day, I think there is no method .toString for Date object type, you can try Date.parse($LAST_DDD.timestamp).toLocaleDateString({‘format’:‘yyyy-MM-dd’})

Thanks,
EmEm

mmussitsch's avatar
mmussitsch
New Contributor II
4 years ago
Copy LinkReport

Thank you for the response.
Unfortunately, even trying to reference “.timestamp” of any kind, I get an error that it can’t be evaluated. Now it’s in the hands of snaplogic support. As an ugly workaround, the formatting of .timestamp can be left alone and instead write the entire results to a file/json and then read back in and manipulated, but we shouldn’t have to do that.

  • alchemiz's avatar
    alchemiz
    Contributor III
    4 years ago
    Copy LinkReport

    Seems like that you need to provide the current format of the timestamp for the Date.parse to work…

    Date.parse($IF_ROW_PROCESSED_DT.Timestamp,“yyyy-MM-dd’T’HH:mm:ss.SSS’+0000’”).toLocaleDateString({“format”:“dd-MMM-yy”}).toUpperCase()