Check date field is empty

Jennifer Fink

• 5 de octubre de 2023 19:42

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.

Vote

1

• 

  Geoff Booth

  • 6 de octubre de 2023 11:19

  • 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
• 

  Jennifer Fink

  • 6 de octubre de 2023 13:18

  Hi Geoff.

  That worked. Thank you very much!

Iniciar sesión para dejar un comentario.