Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Prefill date shows up in form one day behind

246 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Screen Shot 2022-06-24 at 9.47.46 AM

Screen Shot 2022-06-24 at 9.53.39 AM

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

5 Replies 5

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.

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

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.

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})

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