Error when trying to pass a date to a form

Chuck Rodgers

I am getting an error when submit my form, when I pass a date in the URL parameters.

In the URL I am using Datevar = DATEONLY(Date@row)

Which successfully passes what looks like a date to the form.

Example

01/24/22

However when I go to submit the form, I get an error

The information you entered is incomplete or invalid

Dates must be formatted correctly (MM/DD/YYYY)

I have tried using DATE(year, month, day) but it shows up as 1/24/2022 and fails the MM/DD/YYYY.

Any suggestions to overcome this?

Thanks

Chuck Rodgers

Chuck Rodgers

I was able to resolve this issue by unchecking Restrict to Dates only in the column properties for the Date field in the Smartsheet

Chuck Rodgers

I was able to resolve this issue by unchecking Restrict to Dates only in the column properties for the Date field in the Smartsheet