Hi guys! In my latest adventure "new query" I get tangled up with sorting week numbers A to Z.
I use an expression field to convert a date to a week number. Works fine, except when I sort the query on the week number field the weeks go
1
11
12
13
14
15
16
17
18
19
2
20
21 ect. I used Opened Week: Format([Opened Date],"ww yyyy") to display the week and year of the Opened Date field. How do I get it to recognize the week numbers properly?
I use an expression field to convert a date to a week number. Works fine, except when I sort the query on the week number field the weeks go
1
11
12
13
14
15
16
17
18
19
2
20
21 ect. I used Opened Week: Format([Opened Date],"ww yyyy") to display the week and year of the Opened Date field. How do I get it to recognize the week numbers properly?
