Test DateFormula field for empty value

Debbie140
Debbie140 Member Posts: 52
edited 2005-05-19 in NAV/Navision Classic Client
How do I test a DateFormula Field to see if is empty. For example I would test a text field with is it equal to '' and a date string is it equal to 0D.

Comments

  • jreynolds
    jreynolds Member Posts: 175
    FORMAT(DateFormula) = ''
  • PrebenRasmussen
    PrebenRasmussen Member Posts: 137
    Create a local variable of type DateFormula and use this to test:
    IF Rec.DateFormulaField = localDateFormulaVariable THEN...

    (Remember to keep the local variable unassigned!)

Categories