Query Current Date

[Carrie]

How do I get the query to always pull up the current date?

The help button says to put Date() in the criteria line but that doesn't work.

 

[Parra]

Carrie

Did you check to make sure the data type of the field was a Date Field????? Very Important

Go to the table, go to design view. Next to the Date field, does it say Date/Time?

 

[Carrie]

Ok. Let me tell you what I am doing because now it is crashing on me.

I am right mouse clicking on Field: OpenDate. I go to zoom and type...DateValue([OpenDate]).

Then I go to criteria and type...Date().

Then I run the query and it freezes and comes up not responding.

What is it that I am doing wrong. I am definately going to take a night class or something in access.

I really appreciate all of y'alls patients and help.

 

[Parra]

Sounds like you did what you were suppose to.

Did you check the Data Type? Did it say Date or Text???

 

[Carrie]

It says Date/Time. I am working with Acces 2000. Will that make a difference?

 

[Parra]

I'm stupped.

If it is already in a date format then it should work just fine by ONLY adding DATE() in the criteria.

I tried it in a query I'm working on and it worked fine. I don't know what else could be causing your problem.

 

[Carrie]

Thanks anyway.

 

[Parra]

I don't want to give just yet, why dont' you try the following just to make sure everything is set up properly.

In the criteria add the following:
#12/23/02#
Then run the query, this should get you the data with todays current date.

 

[Carrie]

Yes, that worked.

 

[Parra]

OK, I don't know why the Date() function does not work, but in the mean time you can add the following pop up window.

Just add:
=[Enter Date]
In the criteria, a window will pop up and you manually will need to enter the date, in the following format 12/23/02.

This is a temporary solution, till the Date() delima is figured out. Maybe someone else can recommend why the function is not working.

 

[Carrie]

Thanks.