Hello all,
I would like to create a field in my query that can take the week number from my due date ([cx_duedate]) and display it. I am able to find the week number in terms of an entire year (1 being the first week of the calendar year in January, 2 being the second week in January and so on...) using the command ' DatePart("ww", [cx_duedate]) '. I would like to display this on a report, grouped by the current week and future weeks, ignoring previous weeks (1 = the current week, 2 = next week, 3 = the week after next week, and so on...).
It would make my format much easier if this was possible as I am currently having to display the date of the commencing Monday of a given week (CRITERIA >Date() of course).
Thanks in advance.
I would like to create a field in my query that can take the week number from my due date ([cx_duedate]) and display it. I am able to find the week number in terms of an entire year (1 being the first week of the calendar year in January, 2 being the second week in January and so on...) using the command ' DatePart("ww", [cx_duedate]) '. I would like to display this on a report, grouped by the current week and future weeks, ignoring previous weeks (1 = the current week, 2 = next week, 3 = the week after next week, and so on...).
It would make my format much easier if this was possible as I am currently having to display the date of the commencing Monday of a given week (CRITERIA >Date() of course).
Thanks in advance.
Attain the week number beginning at the current week
