cancel
Showing results for 
Search instead for 
Did you mean: 
bsieloff
Nintex Newbie

set variable to date time, null value is equal to 1/1/0001 12:00:00 AM

Hi,

I need to check if a date field (LegalDate) has been filled in.  Date fields don't have the ability to check if it is empty or not (bummer) so I decided to set a text variable txt_LegalDate = LegalDate and then do a run if txt_LegalDate is empty.

Oddly enough the LegalDate field on the list is empty but when I set the txt_LegalDate field equal to the current value (Null) the workflow assigns 1/1/0001 12:00:00 AM to txt_LegalDate.  Huh?

Now I'm checking to see if txt_LegalDate contains "0001".  This works but seems really hokey.  Is there a better way?

Thanks,

-B

0 Kudos
Reply