Date Field Issue

[Santiago Montalvan]

I am having a problem with the date field under option. I go to the table manager and I select the field type to be DATE and then I went to the config.php file and selected numberic_english as the date_format. Then I go to the actual insert form and when I enter the date the drop down options come up as DAY MONTH YEAR instead of the usual MONTH DAY YEAR. Once posted the date shows fine MONTH DAY YEAR but I would like it to be the same when entering the date.

I hope you guys understand what I mean.

Thanks,

Santiago.

 

[TDK]

I also have a problem with the date field, or maybe more of a request for a new feature. I need a date_time type of field. My data contains date_time(as defined in MySQL) type data, i.e. "day month year hour:minutes:seconds", but when the queries are displayed, only the "day month year" part is displayed, the "hour:minutes:seconds" part seems to be discarded.

Does anybody know how to disaply the time as well as the date???

Any help will be much appreciated.

 

[Eugenio]

Santiago Montalvan wrote:

> I am having a problem with the date field under option. I go
> to the table manager and I select the field type to be DATE and
> then I went to the config.php file and selected
> numberic_english as the date_format. Then I go to the actual
> insert form and when I enter the date the drop down options
> come up as DAY MONTH YEAR instead of the usual MONTH DAY YEAR.
> Once posted the date shows fine MONTH DAY YEAR but I would like
> it to be the same when entering the date.
>
> I hope you guys understand what I mean.

You can change:

$date_select = "<td valign=\"top\">$day_select</td><td valign=\"top\">$month_select</td><td valign=\"top\">$year_select</td>";

with:

$date_select = "<td valign=\"top\">$month_select</td><td valign=\"top\">$day_select</td><td valign=\"top\">$year_select</td>";

in /include/general_functions.php, function build_date_select()

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)

 

[Eugenio]

TDK wrote:

> I also have a problem with the date field, or maybe more of a
> request for a new feature. I need a date_time type of field. My
> data contains date_time(as defined in MySQL) type data, i.e.
> "day month year hour:minutes:seconds", but when the queries are
> displayed, only the "day month year" part is displayed, the
> "hour:minutes:seconds" part seems to be discarded.
>
> Does anybody know how to disaply the time as well as the
> date???
>
> Any help will be much appreciated.

Yes, at the moment the time part is not handles.

You can change this behaviour by modifying the function format_date() in /include/general_functions.php

Eugenio.

(Latest version of DaDaBIK when this message was posted: 2.2.1)