DATES ISSUE: Number of the current Week of the current Month 
Author Message
 DATES ISSUE: Number of the current Week of the current Month

in a temporized tape-backup service I designed for a information system
access  based  I would like that it reconizes that a month can have 4/5
weeks, so it could by a simple conditional routine make the backup for each
week.
something like this:

select case ?number of current week in the current month?
    case 1
        ?make the tape backup for 1week?
...

thanks in advance



Mon, 15 Jan 2001 03:00:00 GMT  
 DATES ISSUE: Number of the current Week of the current Month

Quote:

>select case ?number of current week in the current month?
>    case 1
>        ?make the tape backup for 1week?

If Week1 is simply the 1st to the 7th, then
  WeekNo = (Day(dtSomeDate) + 6) \ 7

Tim F

--



Mon, 15 Jan 2001 03:00:00 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. a control that shows only the current month and current year

2. number of the current week

3. Number of the current week

4. adding 3 months to current date

5. Displaying the Current Date and Current Time

6. How Do I Get Number Of Days from Date X to Current

7. Find week of the month based on a date

8. How to chekc if the current year have les or more than 52 weeks

9. Current week in a drop down?

10. how many days in the current month..??

11. Help on SQL statement: all records except the ones on the current month

12. Putting Current month in a variable

 

 
Powered by phpBB® Forum Software