Help

Upcoming database upgrades. to improve our reliability at 03:30 UTC on Feb. 25 / 7:30pm PT on Feb. 24. Some users may briefly experience slow load times or error messages. Learn more here

Date is showing incorrectly in formula if time is not included

Solved
Jump to Solution
535 4
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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

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.