topic Re: IsDate validation of Text time is returning wrong value in Product Forum

IsDate validation of Text time is returning wrong value

AvinashRamkumar — Thu, 05 Aug 2021 01:34:06 GMT

Hi All,

Just tried checking a text value of time with IsDate function and it is throwing result as True.
The expectation is to have the value as False since it is a Time value.

The same result is observed for IsDate(), IsDateTime() and IsTime?

How could we fix this?

Thanks
Avinash

Re: IsDate validation of Text time is returning wrong value

SrinivasaTammin — Thu, 05 Aug 2021 08:00:50 GMT

Hi Avinash,

As per the Microsoft documentation IsDate will return true if it is valid date or valid time or both. As a work around you can use code stage to validate date, Please find the code snippet for Date validation.

This code will Match the date exactly in the format of "M/dd/yyyy", based on our need we can update the format like "dd/MM/yyyy" etc.

Re: IsDate validation of Text time is returning wrong value

ritansh.jatwani — Thu, 05 Aug 2021 21:08:47 GMT

Hi @Avinash Ramkumar,

Since you have used a text datatype inside IsDate() function hence blue prism automatically appends date before the time and gives you the True result. You can first convert the text type to Time/DateTime/Date type and then use the function. It will give correct results.