Options

Test DateFormula field for empty value

Debbie140Debbie140 Member Posts: 52
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

  • Options
    jreynoldsjreynolds Member Posts: 175
    FORMAT(DateFormula) = ''
  • Options
    PrebenRasmussenPrebenRasmussen 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!)
Sign In or Register to comment.