date questions...

[mjonson]

Hi,

when inputting dates ive chosen to have 3 dropdowns
day,month,year

is it best to have three fields for each dropdown
or combine them all in one field?

 

[Bastien]

Combine them, it will make future searches easier

Bastien

Cat, the other other white meat

 

[Kendel]

Use the Javascript Date Picker, the date will show in your input textbox.

 

[mjonson]

thanks for your replies,
kendel - have you got any samples for a good date picker
the best one i found was on 4guys

 

[Kendel]

hey mjonson, I've been using this one:

http://javascript.internet.com/calendars/fuushikaden-pop-up-calendar.html

It works great for me.

 

[mjonson]

thanks kendel great example

 

[mjonson]

right have date entered into mysql table using date picker
format when selected is dd/mm/yyyy
format whene stored in table mm/dd/yyyy
format when displayed in textbox is mm/dd/yyyy

is the format that mysql stores always mm/dd/yyyy ?
how do i get the date to be displayed as dd/mm/yyyy ?
also the mysql table is setup so the date field is varchar
is this ok - ne probs with this?

 

[Bastien]

have a read in the js files. there is usually some definitions on how the date is supposed to look

db column should be date type field

Bastien

Cat, the other other white meat