MS Acess 97 - problems with Dates 2

[tinsel1]

MS Access 97 - when trying to determine a week from a date it is showing a week ahead of what it should be. This has only started happening since the beginning of the year. It is happening to several databases. Any ideas?

 

[lupins46]

I would assume that you have a different method of calculating week 1 than is built into the various date functions that derive it. I think the default position is that week 1 is the week containing Jan 1. If you want something different you must specify it in the functions you are using.

 

[PHV]

Use vbFirstFourDays (ie 2) as firstweekofyear argument.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244