Date function

[vb4me]

Hello,

I need help with a very simple thing - I am having a mental blank.

I have a table with a field that has a variety of dates. I have written a query that prompts you for start date and end date and it will select those records. Quite simple.

What I want to do is instead of being prompted for the start and end date I want to select the current months data.

So I was thinking month(now()) might do it as criteria but it returns nothing - what am I missing.

Any help will be appreciated.

 

[danvlas]

Select WhateverFields From WhateverTable Where Month(YourdateField) = Month(Now);

Is it OK now?



Dan

 

[raskew]

As criteria for a date field, you can employ the DateValue function
to drill down to a specific month & year.

Try adding this query in Northwind then, when prompted for
Enter mm/yyyy, respond with 10/1994.

PARAMETERS [enter mm/yyyy] Text;
SELECT Orders.OrderID, Orders.OrderDate
FROM Orders
WHERE (((Orders.OrderDate) Between DateValue([enter mm/yyyy]) And DateAdd("m",1,DateValue([enter mm/yyyy]))-1));