I am creating a query entity rule where I need to compare one of my ri value whi

Ravi Roshan over 8 years ago

I am creating a query entity rule where I need to compare one of my ri value which is date type with the DB column which is datetime type. I am getting error, Cannot apply operator [EQUALS] to field [UpdatedDateTime] when comparing to value [TypedValue[it=7,v=2016-06-17]].

How to achieve this?

Discussion posts and replies are publicly visible

Parents

0 Ravi Roshan over 8 years ago

Yes, the reason to use fn!userdatetime() is that while using fn!datetime() I was getting mismatch in timing.
The code I pasted above was providing 6/16/2016 4:59 PM PDT when I used fn!datetime() however after using fn!userdatetime() I got exact value i.e., 6/16/2016 11:59 PM PDT
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Ravi Roshan over 8 years ago

Yes, the reason to use fn!userdatetime() is that while using fn!datetime() I was getting mismatch in timing.
The code I pasted above was providing 6/16/2016 4:59 PM PDT when I used fn!datetime() however after using fn!userdatetime() I got exact value i.e., 6/16/2016 11:59 PM PDT
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data