scheduling by week

[vicsaccess]

ok i have a database for maintenance and asset management. once a week we sit down and look at the work that we would like to schedule for the next week. i would like to be able to group the work by week for a few reasons such as being able to look at a particular weeks work and see how we did and also for the maintenance tech to be able to adjust his view to only see the week that his is working on and complete that before moving on to another week. so far my research has pointed to using the datepart("ww",date()) which works great for everything but being able to view it historicly since not everyone can determine that the 43rd week is this monday to this friday. is there a better way of doing what i am after or since i like having the week number that this provides how can i convert a week number that is stored to a monday thru friday view for the persons using the database? any suggestions?

[CJ_London]

have you looked at using format to get the date the way you want

for example

format(Date,"\W\k ww dddd, mmmm dd, yyyy")

will produce

Wk 5 Monday, January 25, 2016

[vicsaccess]

can this be used to convert a week number to a first monday of the week? i like the idea of using the week number for simplicity but not sure if it can be reversed to show a date range of monday to friday.

[CJ_London]

in principle yes - google the use of the weekday and datediff functions, Weekday tells you what day of the week is (1 is sunday, 2 is Monday etc, although you can changed that) so if today is Wednesday (which is 4) Monday would be

datediff("d",weekday(date())-2,date())