Date Format Question - Probably very simple!

[MikeDuffield]

Good afternoon all,

Having built a fairly complex database, I'm ashamed to say I've stumbled on something that's probably very easy to solve.

OK, I have a table full of data. On my form I select a date from a combo box which then generates a report that contains a chart, showing information from the date I have selected.

On the header of the report I've made a textbox that says:

"Information from: [whatever date user selected]"

I would like another text box next to that which says the week number. I've searched the net and can't find anything that solves the issue.

For example, I just want it to say something like:

"Information from: 01/01/10 (Week 1)"

Is this quite easy to do?


Thanks in advance guys & girls!
Mike.

 

[Dairy Farmer]

datepart("ww",[Date1],0,0)

First 0 = Day week starts on (0=system,1=Sun, 2= Mon,.....)
Second 0 = First week of the year (0=system, 1= week in which January 1, 2=first week that has at least four days , 3=first full week of the year)

 

[MikeDuffield]

Thanks for your quick response, it worked wonders

Mike.