Help

Date is showing incorrectly in formula if time is not included

Solved
Jump to Solution
905 4
cancel
Showing results for 
Search instead for 
Did you mean: 
AN_Osajima
4 - Data Explorer
4 - Data Explorer

I’m experiencing a strange issue when I use a date in a formula (yes, I’m using timezones). If I include the time field in the date, then it displays correctly in the formula, but if I do not include time, then the formula displays the date minus 1.
I do not want time because this is an invoice date.
Halp.

Date time_no time

1 Solution

Accepted Solutions
kuovonne
18 - Pluto
18 - Pluto

When you have a date field without a time, the time is automatically midnight, GTM. When you format it in your formula field, don’t set the timezone.

See Solution in Thread

4 Replies 4
JonathanB
8 - Airtable Astronomer
8 - Airtable Astronomer

Could you please share the formula you are using in the {Invoice} field?

kuovonne
18 - Pluto
18 - Pluto

When you have a date field without a time, the time is automatically midnight, GTM. When you format it in your formula field, don’t set the timezone.

The data have changed, but the problem is still the same
CONCATENATE("#",{Invoice #}," - “,DATETIME_FORMAT(SET_TIMEZONE(Date,‘America/Indiana/Indianapolis’),‘M/D/Y’),”, ",Donor)

Ah, thanks. That was the solution. Appreciate the help.