Interaction with Outlook Calendar

[CW]

Here's a nice brain-teaser...
We have several salespeople whose call appointments are recorded in my .mdb
and we want these to be pushed through to their Outlook Calendars.
I followed religiously the advice given in an MS KB Article that fredg had
recommended elsewhere, no. 209963 and I set up the example .mdb and did the
coding and everything looked good.
When I clicked to Send to Outlook I got a confirmation that it had been
done. But I couldn't then find the appointment in Outlook, so I did a couple
more.
It's weird - they are there alright, but the dates have become completely
screwed up and I cannot see the logic for it. The time of day went through
OK, it's just the dates that are not being read properly. This is what
happened:
Access date 06/02/2007 became Outlook date 22/07/2003
Access date 02/05/2007 became Outlook date 23/07/2003
I can (kind of) understand the DD and MM getting mixed up as I am using UK
dates i.e. DD/MM/YYYY but why on earth would 2007 become 2003?????
BTW I am using Office XP Pro (2002).

 

[Bill Mosca, MS Access MVP]

why on earth would 2007 become 2003?????

It's was a better year? Just kidding. It might have to do with how you are
passing the date. Have you debugged the code to see exactly what the date
looks like as it is passed?

We might be able to help if we could see the code you used.