Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Time changes date

Topic Labels: Base design Data Formulas
Solved
Jump to Solution
1543 2
cancel
Showing results for 
Search instead for 
Did you mean: 
ARiios
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi all!

Here's a question... 
I'm making a basic task list in my base, I added a {Due Date} column with field type 'Date' and I have the time also showing in the same column. This will help me schedule tasks by date and time.

Values in {Due Date} look like this '2/14/2024 5:00 pm'. I have another column {Date} with a simple formula 

DATETIME_FORMAT({Due Date}, 'MM/DD/YYYY') so I can get the date alone without the time.

Heres the problem... Everytime I schedule a task pass 6:00 pm in the {Due Date} field, the {Date} value changes 1 day. 

Example:
{Due Date} 2/14/2024 5:00 pm
{Date} 2/14/2024

{Due Date} 2/14/2024 6:00 pm
{Date} 2/15/2024

Help!

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi @ARiios,

Do you have different time zone settings for different fields?
This article will help.

Formulas and Date Fields - Overview | Airtable Support

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Hi @ARiios,

Do you have different time zone settings for different fields?
This article will help.

Formulas and Date Fields - Overview | Airtable Support

ARiios
5 - Automation Enthusiast
5 - Automation Enthusiast

Thanks! 

I didn't have a time zone set, once I did the dates stopped shifting!