Alteryx - how to add a date column

[yilingchen02]

Hi there,

I wanted to pass in a specific date "6/30/2022" and add a column with this date.

I've tried the below formula, but it does not seem to work. The output 'Date' column is null. Any ideas?

Thanks,

Yiling

[Luke_C · Accepted solution]

Hi @yilingchen02 use the format "2022-06-30". This is the accepted date format in Alteryx.

[yilingchen02]

Thanks Luke. That works.