Alteryx Designer Cloud Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Cloud.

Date Conversion

Sifiso
8 - Asteroid

Hi folks

 

please help

 

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

 

 

4 REPLIES 4
alexnajm
16 - Nebula
16 - Nebula

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

alexnajm
16 - Nebula
16 - Nebula

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

Sifiso
8 - Asteroid

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

 

alexnajm
16 - Nebula
16 - Nebula

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