|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
 |
|
|
|
|
|||||||||
|
|||||||||
|
|||||||||
| |
|||
|
|
|
|
| ||||||||||||||||||||||||||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Display Modes |
Dev Articles Community Forums Sponsor:
|
|
|
|
#1
February 3rd, 2005, 05:02 PM
|
|||
|
|||
|
MS Access Date Insert Problem
I am inserting a date into an Access DB, but when the day and month are < 12, the insert swaps the day for the month.
eg. If the date I am inserting is 3/2/04, the database will insert 2/3/04. It is fine when I am inserting a date like 27/4/04. Can anyone shed any light on how to fix this problem? How do i tell the db to keep the formatting correct? Cheers.
|
|
#2
March 4th, 2005, 06:53 AM
|
|||
|
|||
|
I am also facing the same situation. What I did, is to change the time settings in Access? For example from British standards to American or vice-versa.
The DB has no role in swapping. It is its setting of time. Try it and you will see.
|
|
#3
March 15th, 2005, 05:54 PM
|
|||
|
|||
|
I eventually split the date up into 3 dd-mmm-yyyy in Cold Fusion. I have a few servers so it took sometime untill i got them right.
Eg. dd + mmm + yyyy = dd-mmm-yyyy created from 3 seperate variables. Cheers. Leigh
|
|
| Viewing: Dev Articles Community Forums > Programming > Cold Fusion Development > MS Access Date Insert Problem |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
 |
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
