Problem with Date Parameters in Recordset

[jon_sg]

Can anyone help

I need to return records into a DAO recordset based on an SQL statement for the week of a year from a date stored in a table. I have had problems using the DatePart Function as an expression in the query.

Thanks for your help

Jon

 

[RichO]

Specifically, what are you looking for referring to "the week of a year from a date"? Are you looking for a specific week by number (1-52)?

 

[Tim K.]

What error message did you get?

You might use ' instead of " in the SQL statement. Something like this.

SELECT DatePart('ww',Date()) AS WeekNum;

 

[jon_sg]

Thanks folks

It was an embarrassingly simple simple solution really but I couldn't see it Yesterday, Instead of adding an extra col into the SQL stmnt to calculate DatePart("ww"", [Field])and getting the parameter from the form I was trying to compare two date parts in the where clause.

You know what its like after a long day.

Kind Regards

Jon