Hello, I have a date field that is using now() as default. If that time stamp is after or before closing time I need another field adjusted with a new time. I have worked out how to adjust time but not how to get the query to check the time portion of the field with the now() time date stamp as criteria.
I'm not sure if I am saying what I need correctly and your help and direction is most appreciated!