To filter date in expression rule

Question

Hi All, 
 My scenario is to filter the below view column in appian expression rule using the two rule inputs of "date" dataype(startDate,EndDate), 
 
 We can see in screenshot, the column is of text and its in concatenated way, is it possible to filter this from appian? 
 Could you please help me on this. 
 Thanks in Advance.

Harshit Bumb (Appyzie) · Accepted Answer

a!queryFilter(
 field: "parIncludedPeriods_txt",/*field Name*/
 operator: "includes",
 value: concat(text(local!date1,"mm.dd.yyyy")," to ",text(local!date2,"mm.dd.yyyy"))
 ) 
 Change the variables date1 and date2 with your original onces.

To filter date in expression rule

Top Replies