Prefill date shows up in form one day behind

[Doug_Jonidis]

Hello,

I am trying to create a prefilled form that automatically populates the current renewal date for a piece of software. I am running into an issue where the date that shows up in the form is exactly one day behind from what it should be and I can’t figure out why.

As you can see in the above screenshots, the link generates with the date “2023-01-14” but shows up in the form as 2023-01-13.

Any clues as to why this is occurring will be much appreciated!

Thanks
Doug

[ScottWorld]

Since you only need the date (and not the time), then just prefill it with the date and don’t include the time in your prefill.

[Doug_Jonidis]

Hi Scott,

Thanks for your quick reply. I have “include time” turned off in the field that the prefill is pulling from. So, I’m not sure how else to prevent it from trying to populate a time.

If you know of any other way to do this, I’m all ears!

Doug

[ScottWorld]

No, you’ve added a time (midnight) into your prefill URL. You need to take that out of your URL. Just put the date into the URL.

[kuovonne · Accepted solution]

Hiding the time does not affect the value of the field in the formula used to generate the prefilled url.

In the formula for the url, wrap the field name in DATESTR({original date field})

[Doug_Jonidis]

kuovonne:

DATESTR(

Thank you so much, this seems to have worked perfectly!