Date () function

[shaunburke]

I want to use the Date () function in a query, but I want to be able to Enter the Date I want to put in, rather than it be today's date.

 

[ac98]

I know of [ enter date] function... is that what you're looking for?

 

[shaunburke]

I know about that function. I want to put in an expression that puts in each field the date I want to indicate

 

[boblarson]

Use a bound form then.

 

[apr pillai]

Date() Function

I understand that you want to use a Date in a Query Column or in criteria row and you must be able to enter a date yourself rather than taking the System Date, right?

Use the Query Parameter option. Open a Query in design view. Select Parameters option from the Query Menu. Define a Name say myDate and select Date/time data type. Insert [myDate] where you want your date to be used.

When you open the Query in data view it will prompt for the Date and you can respond by entering a valid date in correct format like 05-25-2008.

 

[shaunburke]

PERFECT!! It's the simple things that escape me. Thanks