[ic] How do I modify the layout of the date-widget in the UI?

Paul Jordan interchange-users@interchange.redhat.com
Tue May 28 11:38:01 2002


> Hi list,
>
> I have a date-field in my table that uses the yyyy-mm-dd format (mysql). I
> wanted to be able to modify the date in that field with some kind of combo
> box-solution (one combo per Year, month and date), but the
> date-widget does
> not work for me because it uses the dd-mm-yyy format..
>
>
> Is there any easy solution in how I could handle this, or is it
> possible to
> format the lay-out of the date-widget?
>
>
> Regards, René


Rene, I think you want a "select" box for each portion yes? I recently did
this with a mysql DATE column. The problem isn't with the order of values,
it is with the "-".

I found a tip from Ed L in the archives that states the best idea is the set
that column to char(8) instead of DATE and then use the date widget in UI.
Get rig of all your dashes first though. This works great for me.

Using DATE and UI, the widget thought it should bring in yy-yy-mmdd, and
that is what is screwing you up. DATE definition was not necessary for me,
so I changed it.

I realize that in the db it is now stored yyyymmdd as opposed to
(mm-dd-yyyy), but I don't know, it still works in UI even though UI displays
mmddyyyy. UI does some switcharoonie somewhere I guess.


HTH

Paul