Formula Help 1

[GoodDwayne]

I am writing a formula in BO and I need help. I have a fieldname called Planned Completion Date, Svc Activate Date and another generic field name called PCD On Time. I want to write a formula that will tell me if there is a date under the fieldname Planned Completion Date then to show me if the PCD On Time is labled "On Time or "Late". So far I have this: =If([Planned Completion Date]<[Svc Activate Dt];"Late"). Any thoughts on this?

 

[Charliy]

You mentioned "if there is a date" so you have to allow for there not being one:

if isnull({PlannedCompletionDate})
then "No PCD"
else
if {PlannedCompletionDate} < {SvcActivateDt}
then "Late"
else
"On Time

 

[GoodDwayne]

Thanks Charliy!!!! That worked perfectly!!!