Convert UTC date to date

[mtran21]

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

[dmiller]

I’m double checking, but I think you have to use one of the formats listed in the Parsing a Date example in the documentation.

[dmiller]

@cjhoward18 to the rescue. 🙂
Date.parse("2020-09-01T00:00:00.000").toLocaleDateString({"format":"yyyyMMdd"})

[mtran21]

Thanks, will this work with variable?
Date.parse(“$HIRE_DATE”).toLocaleDateString({“format”:“yyyyMMdd”})

[dmiller]

You shouldn’t need the quotes around the variable, but it should work if it’s a string.