I have a table that uses a general date format, (Date and time). I am trying to break the table down in a report to show Past, Current and Future Dates by assigning a sort value to each group. I am using the following in a queryS1:[DateTime]<Date(),1). Using this I get dates that are less then the current date as planned. When I query DS3:[Date_Time]>Date(),3) I get future dates and the current date. When I use DS2[DateTime]=Date(),2) I get no values. To confirm there are current dates in the table. What am I missing?