Hi All,
I have a column name created date in db as datetime . When I am creating filter in expression rule as createddatefrom and createddateto . I am not able to filter it .
Expression Rule:
a!queryFilter(field: "createddate",operator: "between",value: {todate(ri!createddatefrom),todate(ri!createddatefrom)+ day()},applywhen: not(rule!APN_isEmpty(ri!createddatefrom))),a!queryFilter(field: "createddate",operator: "between",value: {todate(ri!createddateto),todate(ri!createddateto) + day()},applywhen: not(rule!APN_isEmpty(ri!createddateto))),
Please help and thanks in Advance
Discussion posts and replies are publicly visible
try this code
a!queryFilter( field: "createddate", operator: "between", value: { todate(ri!createddatefrom), todate(ri!createddateto) }, applywhen: not( or( rule!APN_isEmpty(ri!createddatefrom), rule!APN_isEmpty(ri!createddateto) ) ) )
Thanks Avinash.