topic RE: How to check if a DateTime data item is empty or not? in Product Forum

How to check if a DateTime data item is empty or not?

Tejaskumar_Darji — Mon, 27 Sep 2021 10:02:00 GMT

How to check if a DateTime data item is empty or not?

I tried these 3 and its not working.

1. [My DateTime]<>""
2. Len([My DateTime])>0
3. Used Filter collection but that throws an error because it supports string only.

If I save "My DateTime" into a Text data item then it automatically saves value 1/1/0001 12:00:00 AM, while "My DateTime" is empty. Stange!!!

How does this work?

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------

RE: How to check if a DateTime data item is empty or not?

krishna.kodimurali9 — Mon, 27 Sep 2021 10:30:00 GMT

Hi, Tejas you can do one workaround if the Datetime data item has value in it.

1.In a calculation stage, try to convert it into some date- for ex - dd-MM-yyyy
2, If it has the value, it will give a value in the output of the calculation stage, if not it will be empty.
3.If it's empty then your Datetime data item is also empty.

Hope this helps.

------------------------------
Murali
RPA Consultant
------------------------------

RE: How to check if a DateTime data item is empty or not?

Carl__Carter — Mon, 27 Sep 2021 11:11:00 GMT

Hi Tejaskumar,

You can use the IsDateTime() function in a Decision or Calculation stage, to test if the data item contains a datetime value.

Hope this helps.

Cheers,

------------------------------
Carl Carter
Senior Developer
Blue Prism
Europe/London
------------------------------

RE: How to check if a DateTime data item is empty or not?

Tejaskumar_Darji — Mon, 27 Sep 2021 12:43:00 GMT

Thanks, Murali & Carl. Both solutions are working very fine and as expected. Thanks for the quick help.

------------------------------
Thanks & Regards,
Tejaskumar Darji
Sr. RPA Consultant-Automation Developer
------------------------------