Date Criteria Doesn Work In My Query. I have a Followup date field in my table. I want to calculate a date like this in the Field.
Between 112017 And 5312017 Query With Changeable Dates. The date field data type is datetime and the format is medium date. To select records within a specific date range with two dates with the AND operator in the query criteria.
The criteria needs the And operator between the dates.
The criteria needs the And operator between the dates. I am trying to create a query for my table where only the data which is today or older will show up. 21 Zeilen Use this criteria. The query runs but its likely the results will be wrong.
