aidisim
Posts: 4
|
| Posted: 11/08/2004, 2:58 AM |
|
Hi,
I am trying to insert a Time into a DateTime field. Initially I tried using a listbox but it does not allow values like 12:15:00 for Date Type. As such I resolve to using Text.
Now it does allow me to insert the time in but it also append the date 1/1/1900 to the field. Is there a way to get rid of the date?
I am using custom insert/update.
Regards
|
 |
 |
kevind
Posts: 251
|
| Posted: 11/11/2004, 2:18 PM |
|
For the Data properties of the field are you setting the date format to h:nn AM/PM from the drop list ?
Regards,
Kevin
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
Aidi
|
| Posted: 11/11/2004, 7:01 PM |
|
Hi,
That will resolve the display problmm but in the database, the 01/01/1900 is still appended.
|
|
|
|
kevind
Posts: 251
|
| Posted: 11/20/2004, 11:57 AM |
|
There are some settings in the Project section of CCS which control the date format - also, what database is this for ?
kd
_________________
thanks
Kevin
======================
CCS 3.2.x / ASP / MS Access /mySQL / PHP / jQuery / jQuery UI / jQuery Mobile
|
|
|
|
|
