H Hans Registered User. Local time Today, 07:14 Joined Feb 6, 2002 Messages 20 Feb 8, 2002 #1 I'm trying to assign a week number to daily records in order to calculate a week to date cumulative. Not sure which direction to take, any suggestions? I had one idea: ((DateDiff(?, Date())/7)??
I'm trying to assign a week number to daily records in order to calculate a week to date cumulative. Not sure which direction to take, any suggestions? I had one idea: ((DateDiff(?, Date())/7)??
D directormac Occasional Presence Local time Today, 07:14 Joined Oct 24, 2001 Messages 259 Feb 8, 2002 #2 If i understand what you're shooting for correctly, check the help file regarding the DatePart() function. You can pass the date and get the week number returned. Then you can sum on records with equal week values. --Hopefully-Helpful Mac
If i understand what you're shooting for correctly, check the help file regarding the DatePart() function. You can pass the date and get the week number returned. Then you can sum on records with equal week values. --Hopefully-Helpful Mac
