Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Enter Same Date for All Rows

Tim6
8 - Asteroid

Hi There!

 

I would like to enter the same date into all rows in my data field

2019-11-30

Is there is way i can do this? I tried to use the formula tool and change the data type to date but i was coming up with an error. Maybe due to the formatting of the date? 

 

Please let me know. 

 

Thank you! 

Jessica

2 REPLIES 2
echuong1
Alteryx Alumni (Retired)

You can use a formula tool to enter the value. Place it in quotation marks. Change the field type to a date.

 

echuong1_0-1609772929299.png

 

Emil_Kos
17 - Castor
17 - Castor

Hi,

 

You can use a formula like this:

 

'2019-11-30'

 

It will work if a field has a date format.


I have provided an alternative solution as well. 

 

Please find attached.

 

Labels