How to set week start number

[holdings]

I'm trying to write a program for my wife for her to keep track
of some school stuff she does. What I'd like for it to do is
be able for her to select a date from the calendar function and
have that set the week start number as 1.

i.e Say she picks Sept.5 to have that start as week number 1. If she
picks Sept.12 have that start as week number 1 etc..

I'm limited in my know how with Access but can fumble thru if
anyone can help me??

Thank you.

 

[chakatheapeman]

VB datepart has week

In Almost all cases VB is going to have all the calendar functions you need. This will return a weak number you can define the start day of the weak. Also define the week of year. I would record the date in the database then display the week number. Microsoft doesn’t have a function to change the week into a date. Unfortunate the start of year is not a cant be just any date. I am not sure but you may have to write some custom code to convert the week number to the first school week, handling the cross over to the New Year as well.

DatePart("ww", date[,firstdayofweek[, firstweekofyear]])

I have had to deal with week number into dates when importing legacy data into my db. The rules about 52 vs. 53 weeks in a year can be a real hardship.

With SQL server you can define custom calendars for fiscal years and such. I don’t think you want to go that route.

I hope this is helpfull