Less than equal to date comparison not working

(0) Share

Report

Posted on by sebgedge

Hi,

I'm trying to retrieve a list of records where the go live date is less than utcnow() -14 days but i am getting the follow error message

Unable to process template language expressions for action 'Condition' at line '1' and column '9668': 'The template language function 'lessOrEquals' expects two parameter of matching types. The function was invoked with values of type 'Null' and 'String' that do not match.'.

all records have a date in them I've tried with formateddate and just utcnow() but have not been able to resolve any help greatly appreciated.

Thanks,
Seb

Categories:

Process Advisor

All responses (1)

Answers (0)

DamoBird365 8,942 Microsoft Employee on at

Like (0)

Report

Re: Less than equal to date comparison not working

Hi @sebgedge,

It sounds like one of the fields is empty to be honest. Presumably you are doing something like
columnname le 'formatdatetime(adddays(utcnow(),-14),'yyyy-MM-dd')'

If you remove the filter and then check the history from a previous run, you should be able to see the field and result that you are comparing against to see what you are playing with. You can also check your date -14 expression in a compose to give you a feel for what is going wrong.

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Cheers,
Damien