Hi folks
please help
I have 2023-02-13 I want it in this format YYYY/MM/DD hh:mm:ss
What are the hh:mm:ss if you don't have that value available?
Assuming you want 00:00:00, this would work: DateTimeFormat([Field], "%Y/%m/%d 00:00:00")
the output data becomes v-wstring, when I choose datetime it becomes null
Correct - date data types in Alteryx can only be stored as yyyy-mm-dd! Any other format will be a string value