Enter Same Date for All Rows

[Tim6]

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

[echuong1 · Accepted solution]

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

[Emil_Kos · Accepted solution]

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.