Concat Formula Query | Community
Skip to main content
J
JenniferCu1
Level 2
August 25, 2025
Solved

Concat Formula Query

  • August 25, 2025
  • 2 replies
  • 262 views

Hi everyone, 

 

I’m looking for some advice regarding an issue with a custom form. My colleague created a custom form that uses a Concat formula referencing a date field from another custom form on the same object in a different format. The formula previously worked as expected, but now displays the date as one day later than the original field. We think this may be related to the time, which is currently showing as 00:00 on all date fields in the first form. Has anyone encountered this issue or can offer guidance?

 

Thank you!

 

Best answer by monicacardoso

Hi @jennifercu1, 

 

Thank you for your question! The root of the issue is almost always related to time zone handling and how Workfront processes date and time fields in calculated expressions:

Workfront stores and calculates all dates in Coordinated Universal Time (UTC), but displays them based on each user’s local time zone.


When you use a calculated field (especially with CONCAT) to reference a date from another form, and the original date field defaults to a time of 00:00 (midnight), the UTC-to-local conversion can cause the date to appear as the next day, depending on your time zone.


For example, if your system is set to UTC-5 (Eastern Time), a date stored as 2024-07-10 00:00 UTC will display as 2024-07-09 19:00 in your local time. If your calculated field is stringifying this value, it may appear as the previous or next day.

 

If you only care about the date (not the time), consider setting the time component of your date fields to noon (12:00) instead of midnight (00:00). This reduces the chance of the date rolling forward or backward due to time zone shifts.

 

If you don’t need to perform date calculations, use a text field to store/display the date exactly as you want it, avoiding time zone conversion. 

 

- Monica

2 replies

M
Adobe Employee
monicacardosoAdobe EmployeeAccepted solution
Adobe Employee
September 8, 2025

Hi @jennifercu1, 

 

Thank you for your question! The root of the issue is almost always related to time zone handling and how Workfront processes date and time fields in calculated expressions:

Workfront stores and calculates all dates in Coordinated Universal Time (UTC), but displays them based on each user’s local time zone.


When you use a calculated field (especially with CONCAT) to reference a date from another form, and the original date field defaults to a time of 00:00 (midnight), the UTC-to-local conversion can cause the date to appear as the next day, depending on your time zone.


For example, if your system is set to UTC-5 (Eastern Time), a date stored as 2024-07-10 00:00 UTC will display as 2024-07-09 19:00 in your local time. If your calculated field is stringifying this value, it may appear as the previous or next day.

 

If you only care about the date (not the time), consider setting the time component of your date fields to noon (12:00) instead of midnight (00:00). This reduces the chance of the date rolling forward or backward due to time zone shifts.

 

If you don’t need to perform date calculations, use a text field to store/display the date exactly as you want it, avoiding time zone conversion. 

 

- Monica

    kautuk_sahni
    Community Manager
    kautuk_sahniCommunity Manager
    Community Manager
    September 16, 2025

    @jennifercu1 Did you find the suggestion helpful? If you need more information, please let us know. If a response resolved your issue, kindly mark it as correct to help others in the future. Alternatively, if you discovered a solution on your own, we'd appreciate it if you could share it with the community. Thank you !

    Kautuk Sahni
    Terms & ConditionsAccessibility statement

    Loading footer...