International date formats

  • Thread starter Thread starter Wayne-I-M
  • Start date Start date
W

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
 
The CDate func helps a bit, but U still have the problem of how to interpret
ambigous dates like 01/11/2008

HtH

Pieter
 
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.



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

HtH

Pieter
Click to expand...
 
Back
Top