Time changes date

[ARiios]

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!

[Sho · Accepted solution]

Hi @ARiios,

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

Formulas and Date Fields - Overview | Airtable Support

[ARiios]

Thanks! 

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