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]

What I would do is check to make sure that the field in the table is formatted as a Date.

That happened to me, then I changed it to a date and it worked fine.

 

[Carrie]

Sounds great but how do I do that?

 

[smozgur]

Hi Carrie,

Say your field name is [MyDateField]. Now change your Field value in Query to DateValue([MyDateField]). And now goto Criteria and use Date().

Now it is working.

Regards
Suat

 

[Carrie]

Sorry I'm so thick but how do I change the Field Value?

_________________
Thanks,

Carrie
This message was edited by Carrie on 2002-12-20 16:29

 

[smozgur]

Hi Carrie,

Just open your Query in design view and then you will see fields in query what you selected (double click on a field in selected table in Query window then you will see it is added into Query Fields below).

Say your field name is MyDateField. Just click that area and change the Text to DateValue([MyDateField]). And then set the Criteria to Date().

I hope I didn't confuse it more.

Suat

 

[Carrie]

You said to just click that area...when I do that it just highlights it...when I right click it I have a choice of build, properties and so on...which do I choose?

I'm sorry but I don't see anything there that says text so that I can change it to date value.

Tell me...am I supposed to put anything inside the parenthesis on "Date ()"

Thanks for your patience.

Carrie

 

[smozgur]

Carrie,

Probably I am not explaining good, sorry. Please send me a sample database or your original database (by zipping please) and let me do it for you.

suat@TheOfficeExperts.com

 

[Carrie]

okay...how do I do that?

 

[Parra]

Hi Carrie, Sorry that I forgot to check the board to see your progress.

If you right mouse click and a list appears, choose Zoom. Then type in the information that the other person told you to type and then go down a couple of rows to the criteria and type in date(), do not add the parenthesis.

Let us know if this helped. Its a slow day so I have some time to help you.