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.

Date & Time Read Incorrectly for Formulas

Solved
Jump to Solution
448 4
cancel
Showing results for 
Search instead for 
Did you mean: 

I have a Date/Time field that feeds into a formula field to pull the date from it. It used to work perfectly well, now that I have added the time option to it as well though there is an issue with it sorted dates wrong.

As an example I have a task that is listed with the date 1/19/2021 7:00pm but when I put it into the formula it reads it as 01/20/2021. If I change the time to 1/19/2021 7:00am it reads it as 01/19/2021.

It does read the Date/Time correctly in Calendar view.

Is there anything I can do to ensure it reads the Date/Time field correctly for the formula? It is important for grouping reasons.

The formula I am currently using is: IF({Due On}=BLANK(), “N/A”, DATETIME_FORMAT({Due On}, ‘L’))

1 Solution

Accepted Solutions

Welcome to the community, @Tashina_O!

This is a tricky one, because this is a time zone issue.

The very first thing to check is to make sure that your GMT time zone setting is set the same for both fields.

If that doesn’t work, you might need to dive into some time zone formulas.

I’ve also created a training video & sample base, which serve as a deep dive into time zones:

See Solution in Thread

4 Replies 4

Welcome to the community, @Tashina_O!

This is a tricky one, because this is a time zone issue.

The very first thing to check is to make sure that your GMT time zone setting is set the same for both fields.

If that doesn’t work, you might need to dive into some time zone formulas.

I’ve also created a training video & sample base, which serve as a deep dive into time zones:

This worked perfectly! I never even thought time zones would have been an issue as it’s just me accessing this in the same timezone I created everything in. Thank you so much for your swift response and the simple to follow tutorial.

Glad I could help! :slightly_smiling_face:

Hi @ScottWorld ! I have a similar issue but I already have my time zone toggled on:

OpsDir_Cassie_0-1674583129883.png

I posted separately about this, but curious if you can identify what my issue is? 

Here's the link to my other post: https://community.airtable.com/t5/formulas/date-amp-time-formula-incorrect/td-p/142546