In DB I have some records with only Date and some records with date& time
Example:
2/1/2023 1:22:31 PM
10/17/2023
11/15/2023
7/07/2022
6/17/2022 2:22:32 AM
11/17/2022
9/28/2022
i need to filter it out with only date but where ever time records available those records unable to filter it out
a!queryFilter(field: "date",operator: "=",value: ri!date)
can someone help me with this
Discussion posts and replies are publicly visible
can you try adding these filters to your rule and check if it helps
{ a!queryFilter( field: "date", operator: ">=", value: todatetime(ri!date) ), a!queryFilter( field: "date", operator: "<=", value: todatetime(ri!date)+1 ) }