Formatting date time

Hi guys,

I want to convert my data like below to YYYY-MM-DD

So I used formula like this, but I had a error. I don’t know what is problem.

Please share your idea… Thanks.

The problem is with the DATETIME() formula.
First try removing the space before the bracket.
What is the type of the CreationDate property? Is it already a date? If so, then you do not need the DATETIME() formula.
If that is simply a text in the format that you show in the first picture then you should be able to use the FORMAT_DATETIME_LOCAL() formula without issues.


I changed data schema date text → date/time text , and I solved this problem.
Thanks :smile: