Date Conversion

[Sifiso]

Hi folks

please help

I have 2023-02-13 I want it in this format YYYY/MM/DD hh:mm:ss

[alexnajm]

What are the hh:mm:ss if you don't have that value available?

[alexnajm]

Assuming you want 00:00:00, this would work: DateTimeFormat([Field], "%Y/%m/%d 00:00:00")

[Sifiso]

the output data becomes v-wstring, when I choose datetime it becomes null

[alexnajm]

Correct - date data types in Alteryx can only be stored as yyyy-mm-dd! Any other format will be a string value