Convert Database Text field into Date error

Question

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