Forum Discussion

mtran21's avatar
mtran21
New Contributor III
5 years ago

Convert UTC date to date

How do you convert this date “2020-09-01T00:00:00.000” to this “20200901”?
mtran21's avatar
mtran21
New Contributor III
5 years ago

I got this error

HIRE_DATE is a datetime data from Oracle

dmiller's avatar
dmiller
Former Employee
5 years ago

Then you should try:
$HIRE_DATE.toLocaleDateString({"format":"yyyyMMdd"})

  • mtran21's avatar
    mtran21
    New Contributor III
    5 years ago

    Got this error

    • ptaylor's avatar
      ptaylor
      Employee
      5 years ago

      Try this:

      Date.parse($HIRE_DATE.toString()).toLocaleDateString(...)

      • mtran21's avatar
        mtran21
        New Contributor III
        5 years ago

        Absolutely beautiful. It worked
        Date.parse($HIRE_DATE.toString()).toLocaleDateString({“format”:“yyyyMMdd”})

        Thank you @ptaylor and @dmiller