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.
Best answer by kuovonne
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.
+29When 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.
Could you please share the formula you are using in the {Invoice} field?
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)
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.
Ah, thanks. That was the solution. Appreciate the help.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
