Hello Everyone, I', trying to get a formular text for lastmodified date in a FORMAT like this

"commentDateTime": "2019-10-08T12:54:44.000Z",

but my efforts to write the formula gives invalid expression

TO_CHAR(TO_DATE({lastmodifieddate}, 'YYYY-MM-DD'))

I have not even got the basic date to work. Any idea what I am doing wrong

lastmodifieddate

is not a CHAR datatype which should make the TO_DATE fail