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
I have a filter for dateTime and it works fine:
a!queryFilter( applyWhen: not(isnull(ri!requestsNewerThan)), field: "createdOn", operator: ">", value: ri!requestsNewerThan )
I would say that the rule input and filtered field both need to be date/datetime).