topic Re: Internal : Cannot perform <> operation when the left-hand value is empty in Product Forum

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

Anonymous — Fri, 23 Jun 2023 20:39:49 GMT

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.

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

MichealCharron — Sat, 24 Jun 2023 14:28:38 GMT

@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])

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

Anonymous — Sat, 24 Jun 2023 16:00:48 GMT

Thanks. It worked.