datepart week not sorting as number

vmon

Registered User.
Local time
Today, 17:58
Joined
Jan 21, 2003
Messages
49
I have graph in a report that show data by week. Problem is the sort is looking at the week as text and not sorting properly. Below is the code. Am I using function wrong or how do I convert "ww" to a number?

(Format([Date],"ww"))

Thanks,
vmon
 

Users who are viewing this thread

Back
Top Bottom