Date & Time Read Incorrectly for Formulas

[AN_Osajima]

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.

[JonathanB]

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

[kuovonne · Accepted solution]

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.

[AN_Osajima]

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)

[AN_Osajima]

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