Help Writing Field Definition?

[J. Williams]

Being the challenged FM user that I am... I can't seem to get a certain field definition calculation written - is someone willing to assist with "defining" the following?

If there is a date in the "Due to HQ" field, then:

If the "DRS Load" field date is after the "Due to HQ" field date, then result is "Submission Missed"

It the "DRS Load" field date is on/before the "Due to HQ Field" date, then result is "Submitted Timely"

If there is no date in the "Due to HQ" field, then result is empty

[mr_vodka]

Case ( IsEmpty (Trim (Due to HQ)) , "" , 

       DRS Load >Due to HQ, "Submission Missed", 

       DRS Load <= Due to HQ, "Submitted Timely", 

     )

[comment]

You can check if a DATE field is not empty simply by:

Case ( DateField , result )

Applied to the current example:

Case ( Due to HQ ,

Case ( DRS Load > Due to HQ , "Submission Missed" , "Submitted Timely" )

)

[J. Williams]

Thank you, thank you, thank you!

Just to clarify, I meant to thank you both!

Edited January 12, 2006 by Guest
Clarification