W
Wayne-I-M
I have posted this to both the Access forum and the Frontpage forum
____________________________________
Hi
Is anyone using a website with an access DB with a time stamp - if you have
how have you got round the time stamps being in different formats.
Driving me mad this one.
Yesterday we got a large number of payments from the UK and Peru (we have an
agency in Lima)
The access DB has a timestamp formatted Time/Date
But this of course stamps the "local" time/date
UK = 13/06/2008
Peru = 06/13/2008
I use the timestamp to validate the payment through PayPal - it's the "only"
non user input that we get on both the PayPal statements and the user input
form (to the on-line DB) so there is nothing else I can use as this is the
only data that’s the same on both streams. Everything else may or may not be
correct – ie. E mail address’ are typed and so sometime wrong on one or the
other (there is no link from the form to paypal so I can’t validate this).
The same goes for the person’s name (yes people spell their names wrong).
Etc. etc. There is only the timestamp to use.
I have tried setting the timestamp to a simple Now() - to force it to UK
format but all this does is load the local time (set from the users computer)
which is based on the regional settings of the machine being used to input
the data.
I "thought" I could code virtually anything
but this has me beat. I
have tried using CDATE but this fails on 01/12/08 and 12/01/08 (as they are
both correct).
I have tried importing the timestamp from outlook as it's received but this
also fails 01/12/08 (and any other combination that "could" be correct)
I have tried using my local server timestamp to update AfterUpdate (but you
still get the "local" time/date
So, unless everyone in the world would like to move to London then I need to
fix this. At the momnet we are importing the DB and simply looking at the
date to see what needs to be changed - not good when there are over a
thousand payment per day
Any Ideas ?? (there "has" to be a way to do this)
____________________________________
Hi
Is anyone using a website with an access DB with a time stamp - if you have
how have you got round the time stamps being in different formats.
Driving me mad this one.
Yesterday we got a large number of payments from the UK and Peru (we have an
agency in Lima)
The access DB has a timestamp formatted Time/Date
But this of course stamps the "local" time/date
UK = 13/06/2008
Peru = 06/13/2008
I use the timestamp to validate the payment through PayPal - it's the "only"
non user input that we get on both the PayPal statements and the user input
form (to the on-line DB) so there is nothing else I can use as this is the
only data that’s the same on both streams. Everything else may or may not be
correct – ie. E mail address’ are typed and so sometime wrong on one or the
other (there is no link from the form to paypal so I can’t validate this).
The same goes for the person’s name (yes people spell their names wrong).
Etc. etc. There is only the timestamp to use.
I have tried setting the timestamp to a simple Now() - to force it to UK
format but all this does is load the local time (set from the users computer)
which is based on the regional settings of the machine being used to input
the data.
I "thought" I could code virtually anything
but this has me beat. Ihave tried using CDATE but this fails on 01/12/08 and 12/01/08 (as they are
both correct).
I have tried importing the timestamp from outlook as it's received but this
also fails 01/12/08 (and any other combination that "could" be correct)
I have tried using my local server timestamp to update AfterUpdate (but you
still get the "local" time/date
So, unless everyone in the world would like to move to London then I need to
fix this. At the momnet we are importing the DB and simply looking at the
date to see what needs to be changed - not good when there are over a
thousand payment per day
Any Ideas ?? (there "has" to be a way to do this)