Format date problem 1

[JAES]

=Format([inDate],"ww")

I'm using this formula to find the week number of a date but I cannot figure out how to change the start day from Sunday to Monday.

I found this syntax for the Format function but can not seem to make it work.

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

Any help is appreciated.

 

[ck1999]

try

Format([inDate],"ww",vbmonday)

ck1999

 

[JAES]

I've tried that. When I enter the vbmonday it automatically changes it to [vbmonday] and the associated subform is blank.

I'm using the expression in an unbound text box and calling a subform from its value. I also use INSERT INTO to put it into a table and I get the error, "There is an invalid use of the .(dot) or ! operator or invalid parentheses." when that is run.

 

[PHV]

And this ?
Format([inDate],"ww",2)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JAES]

Thanks PHV (again). That got it. I tried that at one time but I think the "old" information was still coming up and throwing me off.