Allow inputting of a date range instead of a single date?

[tadeloach22]

So I have a table (Match Log) that is a log of matches.  Right now I have a question for the Date.  What I need is to be able to enter a Date range for multi day matches instead of just a single Date.  Say the match is on the 1st through 3rd of January.  I need to be able to select all three days.  Is this possible?

[shahappsheet]

HI!

I think it might work.

AND([DateFld]>=1,[DateFld]<=3)

Here 1 means 1st Jan and 3 Means 3rd Jan. Obviously, you need to key in these with proper date format.

Hope it will work.

[tadeloach22]

So in other words I would have to have 2 date selections to build the range?

[shahappsheet]

Yah. The same field need to use two times to build the range. Because there is no Between as in SQL. bUT its ok, as long as it works. Please try first. I have used it.