Compare 2 dates and output a specific word in a third field

You can convert work date field types to normal date fields within a different formula field in a formula using

ToDate([My Work Date field])

Then use normal date arithmetic in formuals.

ah, I see. So I need to create 2 new fields to convert the work date fields? Wonder why QB doesnt allow operators on Work date fields. thanks for your help

You can create two new fields but you don't have to.

for example

WeekdaySub(ToDate([my work date field 1]), ToDate([my work date field 2]))

so comparing the dates would look something like this?

WeekdaySub(ToDate([Actual Finish]) <= ToDate([Projected Finish])), On time
WeekdaySub(ToDate([Actual Finish]) > ToDate([Projected Finish])), Late

No, but try this

IF(
ToDate([Actual Finish]) <= ToDate([Projected Finish]), "On time",
ToDate([Actual Finish]) > ToDate([Projected Finish]), "Late")

Wow, that worked. I can't thank you enough. Any chance I could add a color to the field? green for on time and red for late?

Low Tech is to create a new formula Rich text field

IF(
ToDate([Actual Finish]) <= ToDate([Projected Finish]), "<font color=green>On time",

ToDate([Actual Finish]) > ToDate([Projected Finish]), "<font color=red>"Late")

or else
IF(
ToDate([Actual Finish]) <= ToDate([Projected Finish]), "<b><font color=green>On time",

ToDate([Actual Finish]) > ToDate([Projected Finish]), "<b><font color=red>"Late")

If you want fancier background shading, then you will need to use this help here

https://help.quickbase.com/user-assistance/color_field.html

or perhaps cheat off an app in the Exchange called Magic Buttons.

thank you so much, Mark!