Internal : Cannot perform <> operation when the left-hand value is empty

[Anonymous]

Hi,

I have a DateTime column where some row values are empty. I used a decision stage where I used a formula like "If the cell is empty, then add 2 hours. Otherwise, go to the next step". But for the empty cell, the following error is displayed.

"Internal : Cannot perform <> operation when the left-hand value is empty".

It would be great if someone could provide a solution to this problem.

[MichealCharron · Accepted solution]

@Ekram Shihab 

You can use the IsDateTime function to check if a cell is a valid DateTime (a blank cell is an invalid DateTime).

IsDateTime([Details.Completed DateTime])

[Anonymous]

Thanks. It worked.