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!