Check date field is empty

Jennifer Fink

Hello all.

I'm attempting to block the add/update action if any of 3 fields are empty based upon the value of another field. I am able to determine 2 of the 3 fields are empty but the date field evaluation in the macro is completely skipped over.

You can see in the debugger screenshot that @STORE1 is not appended with the value " Needed By".

How do I determine if a date field is empty?

Thanks for any and all assistance.

Comentarios

2 comentarios

Fecha Votos
  • Comment author
    Geoff Booth
    • Step 1 is to find ut what the true value of your field is
    • Set @STORE2 = $[$BOYX_7.0.DATE]; // Capture the field into an @STORE for display purposes
    • MessageBox(@STORE2);  // Often a blank date field will display as 1899-12-30
    • Then code your if statement as required:

    • IF @STORE2 < '1900-01-01'

      BEGIN

        Action

      END

    0
  • Comment author
    Jennifer Fink

    Hi Geoff.

    That worked. Thank you very much!

    0

Iniciar sesión para dejar un comentario.