International date formats

[Wayne-I-M]

Hi

Just starting to create a new on-line booking system linked to access DB -
1st problem (there will be more) - only 6 months till it goes on-line

PayPay assigns time/date stamps in the format of the region of the person
maing the payment not the recipient - so you can have a payment report with
different formats on the same report. Also - noticed that if you are in the
US and your PayPal account is a .co.uk then you will send UK formated dates.

When I import the data I (of course) get errors.

eg.
30/05/2008
(UK) format = 30th May 2008
(US) format = error (there is no 30th month)

05/30/2008
(UK) format = error (there is no 30th month)
(US) format = 30th May 2008

Has anyone got a "whatever" that copes?? or even somewhere to start and I'll
work it out

PayPal does not send IP address with payment reports so I can't use the IP
to check the region.

I can't get PayPal to change the system so need something that will
regognise different date formats and convert them

Many thanks

Any ideas

 

[Pieter Wijnen]

The CDate func helps a bit, but U still have the problem of how to interpret
ambigous dates like 01/11/2008

HtH

Pieter

 

[Wayne-I-M]

Yes you are right

Oh well - I have googled this for hours - no luck.

Sent e mail to paypal and go one back saying they strive to produce the
ideal user experience and how they are sure that I will appreciate the
automated answer to cut down on my valuabe time.
hmmmmmmmmm

There is a way to do this - but not ideal. Paypal sends an e mail quoting
the reciept number as well as us streaming the payment report. I think I
will have to inport this (time/date) from outlook and append using the
reciept number as the primary for a temp table. The reason for this is that
outlook gives a recieved time - if MS can do it with outlook would have
thought ebay could as well - but at least my valuable time is secure in this
wonderful user enviroment.

Life should be simpler than this

--
Wayne
Manchester, England.

The CDate func helps a bit, but U still have the problem of how to interpret
ambigous dates like 01/11/2008

HtH

Pieter