I want to use the Datepart function to determine the week number based on my company's fiscal calendar which starts Nov. 1.

I have tried the following and they all produce #ERROR# .

DatePart("ww",[Change Calendar qry 1]![Target Date],2,"11/01/2005")
DatePart("ww",[Change Calendar qry 1]![Target Date],2,#11/1/2005#)

If leave the Nov 1 date out, I get a result that appears...