Tips and Tricks
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Tips and Tricks
Message Icon Topic: determine 1st Monday of the month based on a patte Post Reply Post New Topic
Author Message
dagz200
Newbie
Newbie


Joined: 06 Aug 2012
Online Status: Offline
Posts: 2
Quote dagz200 Replybullet Topic: determine 1st Monday of the month based on a patte
    Posted: 17 Jun 2015 at 9:30am
I have several different work hrs schedules. They each start at a different date. meaning the first Monday for one schedule is different to the other schedules in any given month. For example 1st Monday on schedule "A" will the second Monday in a month while schedule "B" 1st Monday is the 3rd Monday of the month. The following month for schedule "A" 1st Monday will be the 3rd Monday of the month and schedule "B" will be the 4th Monday of the month. it changes month by month. There is a start date for each schedule to use when it will be the start of that schedule 1st Monday -Sunday and then 2nd Monday - Sunday etc. weeks for each month the 1st Monday will change as it continues the pattern. example:

Schedule A (Start date 6/15/15): 1st Sun - 0hrs (7/12/15), 1st Monday (6/15/15)- 8hrs, 1st Tue (6/16/15)- 8hrs, 1st Wed (6/17/15)- 8hrs, etc 2nd Sun (6/21/15)- 0 hrs, 2nd Monday (6/22/15)- 9 hrs, 2nd Tue (6/23/15)- 12 hrs, 2nd Wed (6/24/15)- 6 hrs, etc 3rd Sun (6/28/15)- 4 hrs, 3rd Monday (6/29/15)- 12 hrs 3rd Tues (6/30/15)- 0 hrs, 3rd Wed (7/1/15)- 0 hrs etc.

Schedule B (Start date 6/22/15): 1st Sun (7/19/15)- 12hrs, 1st Monday (6/22/15)- 4hrs, 1st Tue (6/23/15)- 0hrs, 1st Wed (6/24/15)- 0hrs, etc 2nd Sun (6/28/15)- 0 hrs, 2nd Monday (6/29/15)- 8 hrs, 2nd Tue (6/30/15)- 8 hrs, 2nd Wed (7/1/15)- 8 hrs, etc 3rd Sun (7/12/15)- 4 hrs, 3rd Monday (7/13/15)- 9 hrs 3rd Tues (7/14/15)- 9 hrs, 3rd Wed (7/15/15)- 9 hrs etc.
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.008 seconds.