|
| |
|
|
steveg
Posts: 315
Joined: 10/20/2004
Status: offline
 |
Database date changing display - 8/31/2009 11:43:22
I have an Access database that contains fixtures for our hockey team.
I also have a database that contains Next Home game and Next Away game details along with Last score.
I wouldn't need the Next Game database if I could generate the Next game display from the fixture database.
Is it possible to generate some code that will display some fields of information like day, opposition, date and face off time based upon a comparison to the current date. For example if there was a game on Saturday 5th September, could the next game details identify the record with the game that is next in the list and then when Saturday has passed look for the next game in the list.
We play away and home every week. I also like to show the score of the last game. This data is also kept in the fixture list so could also be displayed in a similar manner, if it can be done at all.
I don't know if I have been clear on this and I will happily explain in more detail if required.
The website is www.chelmsfordchieftains.com and the Next game and last result details can be seen on the home page. If you select team Information from the menu you can choose Fixtures/Results and see the fixtures data table that I have and would like to use as the master.
This would mean that we would not need to update this info every week and it would be automatic.
Any and all help would be gladly received.
Steve
|
|
|
|
steveg
Posts: 315
Joined: 10/20/2004
Status: offline
|
RE: Database date changing display - 9/3/2009 11:28:43
OK. That makes sense. I will create my DRW, give it the Spooky diet and then tweak the selection criteria. Should that process work?
Thanks
Steve
| |
|
|
|
swoosh
Posts: 1574
Joined: 5/18/2002
From: Beaver Falls, PA
Status: offline
|
RE: Database date changing display - 9/3/2009 11:33:52
TWD,
What happens when future game dates are as follows:
January 30
Janurary 31
I'm just trying to learn something here. If the above is the case, which I believe from his site it does happen a few times, how will the 30th date take precedence and how will it exclude the 31st date?
_____________________________
Swoooosh
Just Do It!
| |
|
|
|
steveg
Posts: 315
Joined: 10/20/2004
Status: offline
|
RE: Database date changing display - 9/3/2009 11:39:39
I think that in our case the two consecutive games will be differentiated by Home and AWAY (although I need to check as there could be two games AWAY consecutively, albeit unlikely from a travelling perspective. Thinking about it we may have a midweek game that would be in the range).
I guess I need to pick the next game in the one week range as opposed to potentially two games (both home or away) from that range.
How would I restrict it to the next game only.
Steve
| |
|
|
|
steveg
Posts: 315
Joined: 10/20/2004
Status: offline
|
RE: Database date changing display - 9/3/2009 12:28:13
I have also used Between instead of >= and <= with the same results.
When I change the Date()+7 to Date()+1 I get
Day Date Home/Away Opponents Face Off Competition
Sunday 03-Jan-10 Away Invicta Dynamos 17:15:00 League
Which baffles me even more.
It would appear that the date function is not treated as a consecutive number? (20090905, 20090906 etc.)
Steve
| |
|
|
|
steveg
Posts: 315
Joined: 10/20/2004
Status: offline
|
RE: Database date changing display - 9/3/2009 17:24:08
OK. I've changed the field name to FDate and my code is now:
"SELECT * FROM fixtures WHERE FDate BETWEEN Date() AND Date()+7"
and I get the same 10 results that I got previously.
If I change the last variable to date()+1 I get 1 fixture from 3 Jan 2010??
Steve
| |
|
|
|
steveg
Posts: 315
Joined: 10/20/2004
Status: offline
|
RE: Database date changing display - 9/4/2009 7:45:07
e FDate field is a Date/Time field. I have selected short date in the database but it is still displaying as hh:mm:ss??
The server is a UK server.
Steve
| |
|
 New Messages |
 No New Messages |
 Hot Topic w/ New Messages |
 Hot Topic w/o New Messages |
 Locked w/ New Messages |
 Locked w/o New Messages |
|
Post New Thread
Reply to Message
Post New Poll
Submit Vote
Delete My Own Post
Delete My Own Thread
Rate Posts
|
|
|
Printable Version 
