Problem calculating current week number

  • Thread starter Thread starter Henning
  • Start date Start date
H

Henning

In a form I have an unbound text field in which I want to
display the current week number within current year for
use in a query that drives a subform.
I use the expression =weeknum(now(),2) but it will not
work.
I have tried other solutions, but I am up against a brick
wall.

Has anyone found a way to extract current week number in
an unbound field.

Suggestions will be welcomed.
 
In a form I have an unbound text field in which I want to
display the current week number within current year for
use in a query that drives a subform.
I use the expression =weeknum(now(),2) but it will not
work.
I have tried other solutions, but I am up against a brick
wall.

Has anyone found a way to extract current week number in
an unbound field.

Suggestions will be welcomed.
Click to expand...

Answered in your post of 14 minutes later.
Perhaps a bit of patience might be in order.
 
Back
Top