I use the following formula: CASE WHEN JobCompletedDate IS null THEN null
ELSE PARSE_DATE(“yyyy-MM-dd”, JobCompletedDate)
END
The date shows like this ‘2024-04-25’ and have several null rows.
I received the following error message:
‘I use the following formula: CASE WHEN JobCompletedDate IS null THEN null
ELSE PARSE_DATE(“yyyy-mm-dd”, JobCompletedDate)
END’
how can I solve this?
Thank you.
I want to convert the text field into date
New contributor
Cris is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.