Week numbers problem

  • Thread starter Thread starter Art Vandaley
  • Start date Start date
A

Art Vandaley

Hi,

In access 2007 Beta I have following problem:

text1.value = calendar1.value (text1's format is "ww")

text1 returns 53 for the date of 29.12.2006. Normally it must be 52

How can I fix this problem?

Thanks a lot for your help in advance..
 
One of the optional parameters to the Format() function is firstweekofyear.

Format(expression[, format[, firstdayofweek[, firstweekofyear]]])

Depending on how you define the first week of the year can make a difference.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

week number SOS 3
week number HELP 1
update problem 1
calendar 1
Week number 1
textBox Reference on Access forms 2
Week numbers 2
AJAX UpdatePanel does not refresh after calling Update()-Method 1

Back
Top