Recent content by ruperman

Hi plog, thank you for the explanation, but I thought that the point of the last constant in the function DatePart("ww",#12/31/2001#,2,1) is to tell the function that if the week contains January 1st, then it should be counted as the first week of the new year and not the last week of the...

Hello, I've been trying to create a query that will take a date and return the week number of the date. My original date is formatted m/d/yyyy I need my weeks to start on Monday and I would like the week containing Jan 1st to be the first week of the year I have tried using the following...