I'm creating a timesheet database a

[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
in the default value of a field, but i would like the week number for the date entered to be the control for this value instead. i.e. 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

 

[jon92]

Have a look at thread702-558714
hth

regards jon92

 

[danvlas]

It works...but the date should be passed in US format ("mm/dd/yyyy&quot or in a format that cannot be mistaken: "dd-mmm-yyyy"

I always use the latter - a preference of mine

Try:
Format(Format([YourDate], "dd-mmm-yyyy&quot, "ww&quot


HTH



Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[Samulayo]

Thanks alot, i've got it working now.

Regards
Samulayo