Advanced search by date for timestamp field
Posted: Sun Jan 22, 2023 5:51 am
Hi, is there a way to make the advanced search through a timestamp field by date?
Currently I can enter a date into the advanced search with the date picker but it returns no records possibly due to the Advanced Search Page Operator being set to = meaning it is trying to find an exact match for the record instead of just matching the date. The operator I think I need is LIKE but this isn't an option for this field for some reason. I also tried the IN operator but this didn't return any records either.