Convert UTC date to date

[mtran21]

How do you convert this date “2020-09-01T00:00:00.000” to this “20200901”?

[mtran21]

I got this error

HIRE_DATE is a datetime data from Oracle

[dmiller]

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

[mtran21]

Got this error

[ptaylor]

Try this:

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

[mtran21]

mtran21:

({“format”:“yyyyMMdd”})

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

Thank you @ptaylor and @dmiller