In (x,y,z) question

[bknight]

I have a field that is date/Time format. For a given set of Days could be grouped by filling in the interior with the dates desired, but this is a manual operation. Is there a form which would allow a current week dates to be included, whatever the week may be just the current week?

[HansV]

You might create a rule of type Expression Is with formula

[DateField]>=Date()-Weekday(Date())+1 And [DateField]<Date()-WeekDay(Date())+8

[bknight]

In a criteria line?

[HansV]

I thought you wanted to create a conditional formatting rule.
If you want to return only records for the current week in a query, set the Criteria for the date/time field to

>=Date()-Weekday(Date())+1 And <Date()-WeekDay(Date())+8

[bknight]

Works for today, thanks.

[bknight]

Well, I spoke one day too soon.
Image of query that works displays 2 records 5/20 and 5/21. Second image is of form with query as recordset, this doesn't work. I get only one return record with #Name? for the first field. Any ideas?

[HansV]

Impossible to tell without seeing the database

[bknight]

You always say that with a smile.

[HansV]

This is what I see when I open the form:

S2551.png

[bknight]

I see that also when I re-opened. It did as I described, so why the change after closing and re-opening?

[HansV]

Perhaps the query had to be run again. Otherwise, I wouldn't know.

[bknight]

I don't know either.