Workfront Custom field | Community
Skip to main content
A
AbisheikMe
Level 2
February 10, 2026
Question

Workfront Custom field

  • February 10, 2026
  • 1 reply
  • 16 views

Verifying On-Time Delivery logic in Workfront: same-day date comparisons

We are implementing an On-Time Delivery KPI where work is considered on time if the Actual Completion Date is the same day or earlier than the Planned Completion Date.

However, even when both dates appear as the same day in the UI (with different times), comparisons using <=, DATE(), DATEDIFF(), and DATENOTIME() sometimes return late.

Is this expected due to Workfront storing DateTime values in UTC?

What is the officially recommended approach for calendar-day-based SLAs in Workfront?

What is the way to compare only date without time ?

1 reply

A
AbisheikMeAuthor
Level 2
February 11, 2026

I need a confirmation that can we write formula to calculate the date (only) without time.

If({actualcompletiondate}<={plannedcompletiondate},1,0)

this works, but on same date it shows 0 when the time differs.

Is there any possibility to avoid time to show 1 on same date. 

skyehansen
Community Advisor and Adobe Champion
skyehansenCommunity Advisor and Adobe Champion
February 11, 2026

​@AbisheikMe  -- I think I gave you this link earlier in the week, but here it is again:

https://experienceleague.adobe.com/en/docs/workfront/using/reporting/reports/calculated-custom-data/calculated-data-expressions

 

it’s a good reference. Usually when time differs I use the cleartime function you should be able to locate on this page.

A
AbisheikMeAuthor
Level 2
February 11, 2026

Thanks for your confirmation

 

Terms & ConditionsAccessibility statement

Loading footer...