DateDiff is not working


#1

Hi, I am trying to use a filter as such

However, I keep getting this error

"Invalid or unparsable field in filter request.",

Can you please help me out with this?

Thanks and Regards
Gagan


#2

@gj1118 I don’t believe DATEDIFF function is supported in filter you might try creating function in SQL and calling stored function from API for this. Looking at wiki article here it seems they list the available filters: <, <=, >, >=, =, or, and, like.

Not sure if there are any unmentioned filters.