473,327 Members | 2,103 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,327 software developers and data experts.

Determining Holiday Dates for Athletic Game Schedules

8
Hello:

Thanks for reading my post. I am trying to generate Athletic League schedules using Access 2003 and Windows XP PRO. I am using DateSerial in a text box to print the game dates on the League schedule report. This is the control source for one of the dates on my report.

=DateSerial(Year([Date2]),Month([Date2]),Day([Date2]+7))

The problem I am having is that if the day is a Holiday then I do not want to print the schedule information for that particular day, I want to print for example "NO GAMES".

How do I determine which dates are Holidays, and then skip the printing of a particular game day?

Thank you for your assistance.
Oct 30 '08 #1
2 1482
Stewart Ross
2,545 Expert Mod 2GB
Hi BeckR. You need to think how you would do something like this manually, as if you can come up with a way to do so it guides you how to automate it. So how would you yourself determine what is and is not a holiday? You would look up a calendar showing holiday dates for that year.

That is what you will need to build in to your application. A calendar is just a specialised form of table covering one complete year, so in your application you must provide a holiday table where you list the dates (and names for reference) of each and every holiday that you don't want included in your league dates.

You can automate certain rules without the use of a table (for example, if it was always the case that no matches would be played on Mondays) - but holiday dates are not automatable as there are always annual variations in when these occur within the year, and there can also be local holiday variations in the designated holiday dates within a particular geographic area. A table of dates updated annually and then used as comparators in your printing routines is the only way you can accomplish what you ask.

-Stewart
Oct 30 '08 #2
BeckR
8
Hi Stewart

Thank you for the information and pointing me in the right direction. I think I know what I need to do now.

BeckR
Nov 2 '08 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

8
by: Joshua Beall | last post by:
Hi All, I am wondering what the best way to determine an age of something/somone is. For instance, let's say I have two dates: 1985-07-19 2003-11-30 Now, I want to determine the interval...
4
by: Dean | last post by:
I am a developer who works with MS SQL Server a lot, but I'm far from an expert. I am revamping an appointment scheduling system that allows for appointments to reoccur daily, weekly, monthly and...
1
by: bigfella | last post by:
Hi Everyone, I am using the following code (many thanks for the code folks BTW) to generate 3 schedules in three tables one is a schedule with 7 day intervals and two are daily schedules. The...
1
by: Chris Strug | last post by:
Hi, As something of a pet project, I'm looking to develop a tool to track employee holiday (or vacation for those of us in the US) for my company - good for the company (if I get something...
26
by: Yeah | last post by:
I have a web site which changes the header logo based on the upcoming holiday. For example, from December 10th to 25th, XMAS.JPG is displayed. From October 20th to 31st, HALLWEEN.JPG is...
6
by: Jana | last post by:
Greetings Access Gurus! I am working on an app to send batch transactions to our bank, and the bank requires that we place an effective date on our files that is 'one business day in the future,...
2
by: Eamon | last post by:
Hi all, I'm trying to find a way to list all the jobs/schedules due to run between two dates but all I seem to be able to get is a list of jobs with their NextRunTime. Example: Say I had two...
2
by: shubhra | last post by:
I am creating a game application in jsp. I want to permit user to play this game between specific dates entered in the DB for that particular game. How could I make it work between those days....
5
by: cla | last post by:
I'm using this code on an application to track football schedules: ---- $season = '2005'; $basedate = strtotime('this friday', strtotime('31 August '.$season)); for($d=0;$d<=31;$d++) {...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.