AnsweredAssumed Answered

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

Question asked by bsieloff on Oct 8, 2017

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

Outcomes