Gossamer Forum
Home : Products : Gossamer Links : Discussions :

New date: add field and display format

Quote Reply
New date: add field and display format
I have added a column to the database that requires the user to enter a date. I would like the date to be a criteria (3) for searching the database. I would prefer that it not be in text format.

I am having two problems:

(1) The date field displays the database default format of 0000-00-00. How do I setup the field so the user can enter a date in various format that will still be stored in the database? Should I be using pull downs for day, month, year? Other suggestions?

(2) How do I get the date to display in a format other than the default format?

Is text format my only option?

ACW
Subject Author Views Date
Thread New date: add field and display format awhite 2076 Jun 20, 2005, 11:35 AM
Thread Re: [awhite] New date: add field and display format
Alba 2020 Jun 20, 2005, 12:58 PM
Thread Re: [Alba] New date: add field and display format
awhite 2020 Jun 20, 2005, 2:21 PM
Post Re: [awhite] New date: add field and display format
Alba 2003 Jun 21, 2005, 1:23 AM