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

mtran21: ({“format”:“yyyyMMdd”}) Absolutely beautiful. It worked Date.parse($HIRE_DATE.toString()).toLocaleDateString({“format”:“yyyyMMdd”}) Thank you @ptaylor and @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.

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

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

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

Convert UTC date to date | SnapLogic - Integration Nation

Coyote

Google Sheets Subscribe questions

3 months ago

jfpelletier

Basic string transformations not working

Solved

3 months ago

darshthakkar

Forum Discussion

Convert UTC date to date

Recent Discussions

401 error with HTTP Client and NTLM

Pagination and nextCursor in header

Javascript to promote top level lists

Google Sheets Subscribe questions

Basic string transformations not working