My Assistant
Site Message (Message will auto close in 2 seconds)
Custom Search
|
  |
 Booking Calendar |
 Nov 4 2008, 02:37 AM Post#1 | |
Posts: 64 Joined: 24-March 08 From: Australia  | I have a need for a booking database similar to one posted by Cybercow et al - ApptCalendar2003 live in Australia where our date format (dd/mm/yyyy) is different to the US (mm/dd/yyyy) ApptCalendar2003 is a good basis to start from but the date format makes the database fail. If I enter an appointment for 04/11/2008 (4th November 2008), the large calendar displays it correctly. However, the Calendar_Daily form does not display the appointment. This is because the code (ApptDate = #" & dtePubMyDate & "# ) is interpreting the date as US format (11th April 2008) Does anyone have a solution to this? Nigel. |
 |  |
| Nov 4 2008, 07:05 PM Post#2 | |
Posts: 64 Joined: 24-March 08 From: Australia | I have solved the problem. No replies required. |
| |
| Nov 12 2019, 11:37 AM Post#3 | |
Posts: 2 Joined: 12-November 19 | I know it was a while back but if you are still around would you mind telling me your solution please Regards spursmalt |
| |
| Nov 12 2019, 11:42 AM Post#4 | |
 UtterAccess Moderator Posts: 11,885 Joined: 6-December 03 From: Telegraph Hill |  >> This is because the code (ApptDate = #" & dtePubMyDate & "# ) is interpreting the date as US format (11th April 2008) << Change this to: CODE ApptDate = Format(dtePubMyDate, "\#yyyy\-mm\-dd\#") hth, d -------------------- Regards, David Marten |
| |
| Nov 13 2019, 07:19 AM Post#5 | |
Posts: 2 Joined: 12-November 19 | Perfect.....many many thanks Spurs |
| |
| Nov 13 2019, 07:38 AM Post#6 | |
UtterAccess Moderator Posts: 11,885 Joined: 6-December 03 From: Telegraph Hill |  -------------------- Regards, David Marten |
| |
|
Custom Search
|
 | Search Top Lo-Fi | 8th December 2019 - 08:11 AM |