week number

  • Thread starter Thread starter Jean-Paul
  • Start date Start date
J

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
 
See the DatePart function; it allows you to get the week number from a date.
 
Back
Top