- Joined
- Jul 12, 2007
- Messages
- 45
- Reaction score
- 0
Greetings Databasers! 
I would like to know how you can set up dates in combo box that generates the date automatically based on code.
The two fields would be WEEKDATESTART and WEEKDATEEND. The WEEKDATESTART needs to be a combo box with the default being 'Date()-Weekday(Date())+2', setting Monday as the first of the week, and Date()-Weekday(Date())+7 at the end of the week(Saturday).
The combo box needs to be able to generate upto 3 addition weeks (making a total of four weekdate codes, making a month). The WEEKDATEEND needs to fill itself in by the coice within the WEEKDATESTART combo box.
I tryed to put in the codes in the combo list, but thats' all that shows (the code, not the date). Please help.
Thankyou in advance
MCB
I would like to know how you can set up dates in combo box that generates the date automatically based on code.
The two fields would be WEEKDATESTART and WEEKDATEEND. The WEEKDATESTART needs to be a combo box with the default being 'Date()-Weekday(Date())+2', setting Monday as the first of the week, and Date()-Weekday(Date())+7 at the end of the week(Saturday).
The combo box needs to be able to generate upto 3 addition weeks (making a total of four weekdate codes, making a month). The WEEKDATEEND needs to fill itself in by the coice within the WEEKDATESTART combo box.
I tryed to put in the codes in the combo list, but thats' all that shows (the code, not the date). Please help.
Thankyou in advance
MCB
Last edited: