Statistics Report - Pull info. entered today?

[SherryLynn]

I have a report with date parameters (start and end). Is there some way to pull only those records which had data entered on todays date? or yesterdays? Help.

Sherry

 

[MichaelRed]

For today, set [start] = Date() or Format(Now, "Short Date&quot and [end] = Date() + 1 (or Format (Now() + 1, "Short Date&quot

Variations on this theme should be pretty obvious.

The 'trick' here is to understand that "dates" are stored as Double type, witht the integer (long) part as the offset from a starting date and the decimal part reresenting the time (actually proportion of the day). Now is th e whole thing (Integer and decimal). Date is JUST the integer.

Consider the following:

? Clng(Now)
37062
? Format(Now, "Long Time&quot
12:43:59 PM
? Format(Now, "Short Time&quot
12:44
? Cdbl(now)
37061.5305671296
? Date()
6/19/01
? Date + 1
6/20/01
? Date - 1
6/18/01


MichaelRed
redmsp@erols.com

There is never time to do it right but there is always time to do it over