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
First of all, DB won't allow to save DATETIME value in DB when the column type is DATE.