Hello,
I'm trying to achieve a date comparison formula.

This is my formula but it's not really working:

if {@Ship Date Only} > {@Promise Date Only} then "Yes" else "No"

Can you please help me with this??

it gives me a blank field on some of the dates even though they're later (12/16/2016 and 12/19/2016).

The formulas are:

{@Ship Date Only}:
If isnull ({V_RELEASES_COMB.SHIP_DATE}) then
DATE({V_RELEASES_COMB.ACTUAL_SHIPDATE}) else
DATE({V_RELEASES_COMB.SHIP_DATE})


{@Promise Date Only}:
DATE({V_RELEASES_COMB.PROMISE_DATE})

Dell,

That cleared my question. Thank you so much!