Unable to Query Time
Aeries Query can recognize dates BUT it cannot query Time. (ie if you want to query out a time range (9:30 Am thru 12:30 PM), you cannot use IF ST >= "9:30 AM" AND ST <= "12:30 PM"). Any time manipulation needs to happen in Excel. Please make a way to query out time!
5
votes
Loren Sorensen
shared this idea
-
Adminheidi
(Admin, Aeries Software)
commented
Actually you can query by time. But if the field is Date Time you need to add the date in there as well.
Try something like this: You can add seconds or leave them off.
LIST LOG BY DTS IF OB : STU AND DTS > "8/23/2023 8:08 AM" AND DTS < "8/23/2023 12:58:53 PM"
