I have a list dialog setup on one of our cabinets where the criteria used is:
Store Date – Is (where clause) – CURRENT_DAY() .
This works fine and dandy until 4:00PM each day. At 4:00PM PST, it is midnight GMT time. So anything meeting the criteria doesn’t show up until tomorrow in the List.
Do you know of a way to fix this?