UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
 
   Reply to this topicStart new topic
> Booking Calendar    
 
   
nigelq
post 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.
Go to the top of the page
 
nigelq
post Nov 4 2008, 07:05 PM
Post#2



Posts: 64
Joined: 24-March 08
From: Australia


I have solved the problem.
No replies required.
Go to the top of the page
 
spursmalt
post 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
Go to the top of the page
 
cheekybuddha
post Nov 12 2019, 11:42 AM
Post#4


UtterAccess Moderator
Posts: 11,870
Joined: 6-December 03
From: Telegraph Hill


welcome2UA.gif

>> 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
Go to the top of the page
 
spursmalt
post Nov 13 2019, 07:19 AM
Post#5



Posts: 2
Joined: 12-November 19



Perfect.....many many thanks

Spurs
Go to the top of the page
 
cheekybuddha
post Nov 13 2019, 07:38 AM
Post#6


UtterAccess Moderator
Posts: 11,870
Joined: 6-December 03
From: Telegraph Hill


yw.gif

--------------------


Regards,

David Marten
Go to the top of the page
 


Custom Search


RSSSearch   Top   Lo-Fi    6th December 2019 - 08:11 PM