Help

Time changes date

Topic Labels: Base design Data Formulas
Solved
Jump to Solution
674 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!