Creating a date_hour Field

[sperson]

Hi, how can i add a date_hour field using the module builder?

If it's nor possible can i add an hour field at least?

Tanks.

[andopes]

Hi sperson

How do you want to use that field?
You could add a dropdown field (values 0 - 23).

Cheers

[sperson]

Hi Andre, i need to create a field for schedulling a case attendance, fro example.

The customer wants to schedulle the tecnical visit for 20/09/08 at 23:30.

I need to create a field called "Schedulled to:" and them i just select the date and time.

Actually i created two fields, one for the date (date field) and one for the hour (text_field with 5 caracters)

Thanks.

[mikesolomon]

To create a date time field I added a date field then changed vardefs to make it a datetime field

'date_start' =>
array (
'required' => false,
'name' => 'date_start',
'vname' => 'LBL_DATE_START',
'type' => 'datetime',
'massupdate' => 0,
'comments' => '',
'help' => '',
'duplicate_merge' => 'disabled',
'duplicate_merge_dom_value' => 0,
'audited' => 0,
'reportable' => 0,
'len' => '25',
),

Then run a repair

I also changed editviewdefs to set the type

array (
'name' => 'date_start',
'type' => 'datetimecombot',
'label' => 'LBL_DATETIME_START',
),

[sperson]

Hi Mike, thanks for the reply, i just have one more question. Where is locate this vardefs file ?

Because this is not a native field i imagine that this code is not in the /modules/Cases vardefs file.

Where are locate the vardefs related do new fields created by the user.

Thanks

[mikesolomon]

Hi Mike, thanks for the reply, i just have one more question. Where is locate this vardefs file ?

Because this is not a native field i imagine that this code is not in the /modules/Cases vardefs file.

Where are locate the vardefs related do new fields created by the user.

Thanks

Ah good question

My field was on a custom module so it was in vardefs

I also changed a field in Tasks but again not a custom field

The field definitions for custom fields are held in the database table fields_metadata

You could try changing the type there then doing a rebuild and seeing if that works