Date without Time report

drarem · July 9th, 2004, 10:40 PM

See subject, that is basically what I want.

I have the shortdate format in my table, forms, and report fields.. My query looks like:

Between DateAdd("d",[Forms]![CreateReport]![Text4],0) And DateAdd("d",[Forms]![CreateReport]![Text0],0)

I've also tried:
>=[Forms]![CreateReport]![Text4] And <= [Forms]![CreateReport]![Text0]

My report generation for some reason includes the time the record was created, because sometimes I get let's say this on a search for:

7/2/2004
7/3/2004

Only lists an item for 7/2/2004

7/2/2004
7/4/2004

Lists both items, 7/2 and 7/3

A query of:
7/17/2004
7/19/2004
lists items 7/17 and 7/18, not the 7/19

but a query of:
7/17/2004
7/20/2004
lists items 7/17 thru 7/20/2004

How do I change my Query to look at only the date typed in the Form Textbox and compare it to the date in the Table and completely ignore the time of entry which I guess is invisible at this point but is factored in.

How I found out.. I changed my Create Report form textbox to include the time, and by changing the time range from 0:00 in first and 23:00 in second textboxes, it did include the reports.

Thanks.

aCk!

smercer · July 11th, 2004, 10:06 AM

in the table design, do you have

Code:

=Now()

for the default code in the date field?

if it is try using instead:

Code:

=Date()

But you want date and time in other forms, reports and what-not's you say?
That's okay just create a field for time as well, but for the report you want to omit the time just take out this field.

Try this in the criteria instead

Code:

between [Please enter the date from which you want records filtered] And [Until when]

Hope this helps
good luck

Never give up on what you are trying to achieve because the potential is always there

drarem · July 13th, 2004, 10:43 PM

that works perfectly, using the Date().. thanks :)

aCk!