DateAdd + week number not matching

[oni1983]

I am currently trying to convert a number of dates to week number by using DatePart([“ww”],[1 Visit],[vbMonday],[vbFirstFullWeek]).

[1 Visit] is the name of the field where the dates to be converted are. As you may note, as soon as I write the code [] appear next to vbMonday and vbFirstFullWeek and it's not working.

Can someone help?

 

[xenou]

Hi, Don't put brackets around vbMonday or vbFirstFullWeek (or for that matter around "ww"). Brackets go around field names and table names. Plus, these named constants will only work if you are using the expression in a vb function or sub (in the code window).

It looks like it does work if you use the integer values for the constants:
DatePart(“ww”,[1 Visit], 2, 3)

for the values of the named constants see: MS Access: DatePart Function

 

[oni1983]

Thanks for the help and for the link! the integer values worked perfectly!!!