Pls help with date filter

[qulaitks]

I have report created and I wanted to view only today events.I have traied maydate=today() and now() functions but they did not work.Please help.

Regards

 

[jwhite]

How about posting the code segment where you are trying this? Is maydate a Date/Time field?

 

[qulaitks]

I am adding this functions at the report properties filter

 

[battenberg]

make sure that your report is based on a query that has the date field you wish to filter.

then add your

=date() or =now()

to the criteria in the date field in the query

 

[qulaitks]

Thanks for the respond, I have tried it and I had blank list.

 

[gemma-the-husky]

take the query to are trying to text, without using the report.

design the query with no criteria to ensure it is working - it should return every record
---------------------
click on the date column you are testing, and click Z-A to make sure you have some values with today's date

---------------------
now in that column that has the data you are testing

in the criteria column put

= date()

assuming that your column has a date only in the column (ie no time) this should now select all of today's items.

--------------------------

 

[qulaitks]

Thanks for the respond. I tried what you have mentioned and I did not work. I have attached the query.

 

[gemma-the-husky]

can't look at this the dbs wont open - is this in A2007?

 

[qulaitks]

It is A2003.

 

[ansentry]

qulaitks,

Here is your db back and working.

I have created a new table, query and report.

In your table you had Now() as the default for the Date Field. That mean that when a record is created it get "NOW" date, time (including seconds), so when you try use criteria of date it will only return the one record. Open your query and then click the date in the date field and you will see that it is not just the date, but the time- down to the second.

Also I would suggest that you don't use date as a field name, it is a reserved word in Access and if you continue to use it you will run into problems.

 

[qulaitks]

Thanks alot.