How to Check if DateTime is empty

[StephanKnoell]

Calculation formula to check for empty DateTime variable:
InStr(Trim([dateTime]); "01.01.0001")=0  

Empty DateTime variable in Blue Prism results in "01.01.0001 00:00:00" which corresponds to value of Field DateTime.MinValue: DateTime.MinValue Field (System)

Microsoft		remove preview
DateTime.MinValue Field (System) public: static initonly DateTime MinValue; public static readonly DateTime MinValue; staticval mutable MinValue : DateTime Public Shared ReadOnly MinValue As DateTime Field Value The following example instantiates a DateTime object by passing its constructor an Int64 value that represents a number of ticks. View this on Microsoft >

#BPTechTips
​

------------------------------
Stephan Knoell
Senior Developer
Roboyo
Munich
------------------------------

[Satish1414 · Accepted solution]

Hi Stephan ,
You can use IsDate() and IsDateTime() expression to validate the Dates .It would return a flag of true/False . 


Hope this helps .

Thanks ,
Satish Gunturi
Senior Consultant
Ignite IPA Pvt Ltd

------------------------------
Satish Gunturi
------------------------------

[StephanKnoell]

Hi Satish,

thats an even better way. Thanks!

Best,
Stephan

------------------------------
Stephan Knoell
Senior Developer
Roboyo
Munich
------------------------------

[Tejaskumar_Darji]

Adding reference for a similar thread for future references.


------------------------------
If I was of assistance, please vote for it to be the "Best Answer".

Thanks & Regards,
Tejaskumar Darji
Sr. Consultant-Technical Lead
------------------------------