Form validation using different time zone than date/time field

I’m trying to set up form validation for some date/time fields but the validation seems to be using a different time zone than I’m set to (EST), perhaps its using GMT. I checked my setting in airtable and it’s correct, I can’t find any options to change in noloco. How do I get this validation accurate?

What are the settings in Airtable @onlymatt , and were they recently changed?

This will have a big impact on the scope of this potential bug.

Thanks

These settings haven’t been changed since the fields were created which was long before I started with noloco but I can’t say exactly how long.

Okay, thanks for clarifying!

Just to confirm a few things, the validation itself is working right? It’s just the time in the validation error message?

Thanks

Yes it was correctly validating, just the time it was displaying was off by 4 hours

1 Like

I’m having the same issue. Using Smartsuite as my data source. Was this a bug? Or a setting?

Same issue here. I’m trying to filter and group a list of records by date and time but there seems to be an issue with the date format and/or timezone settings.

Everything is working fine in AirTable. I have a date field set to the desired timezone (same timezone for all collaborators - enabled) and the dates and times are correct. The field settings have not been changed in the past few months.

For testing purposes, I created a secondary date field, copied over the data, and set it to GMT. The results in Noloco are identical.

I also tried creating formula fields that output a valid date in Airtable, but Noloco doesn’t recognize them as such (no relative date filter option available).

Does anyone have any updates on how to make this work in Noloco?

Hi @Jacob_MTS - could you send us the link to this issue and we can try to narrow down what’s happening?

Linking us to the page you’re trying to filter will help us understand your setup and what exactly you’re doing.

Thanks

@darragh sure thing! Unfortunately I can’t share the data publicly, but I’m more than happy to share links with the support team. I reached out a couple of days ago but still no response. Thanks!

1 Like