week number

[Jean-Paul]

Hi,

I have a table containing names of firms and dates on which they should
be visited.

I want something like: all firms that should be visited in week number 24

Is there somebdoy out there who is able to explain?

Thanks

 

[Ken Snell \(MVP\)]

See the DatePart function; it allows you to get the week number from a date.