WeekNo of a date

[Samulayo]

I'm creating a timesheet database and the entry of a new timesheet requires the date and week number that the timesheet corresponds to. I know how to find the week for the current date using
=Format(Now(),"ww&quot
but i would like the week number for the date entered to be the control for this value instead. ie something along the lines of
=Format([date],"ww&quot
where [date] is the field 'date' on the table (btw that does not work as life's not so simple.)
and help with this would be greatly appreciated.

Regards

Samulayo

 

[Samulayo]

Sorry about this, just to make things clear, i wanted this value to be in the 'default value' of a field

 

[fredk]

I am a little confused - If you are entering your data from a form, why don't you create an event procedure in the after update event of the "date" field that updates your "weeknumber" field.

Something like:

Private Sub date_AfterUpdate()
Me.weeknumber = Format([date], "ww&quot

End Sub

Hope that helps.

Fred

 

[Samulayo]

Fred,
I eventually used this approach after realising that something similar tot he above sub would make more sence. Thanks anyway

Regards
Samulayo