Add datatype date/time

[dvelguru]

I noticed the datatype is used for the date_start of scheduling activities ...

When using editviewdefs.php type => datetimecombo my date/time does not save even after I converted the datatype of a field in DB to DATE/TIME.



So I will have to modify save() to do this.

Maybe this is available and I just don't know how to do it. But I don't think so as there are no date/time data type options when adding fields to a module.

[dvelguru]

Alright, I can definitely see why it would be a hassle to have a feature like this.

[datasponge]

Hi dvelguru,

You can't add a datetime field through studio, but you can add it as an extension.

I added a datetime field called note_date to the Notes module so that I could set the date something occurred as distinct from the date the record was created or modified.

To do this I added a new file with the path:

<sugarcrm>/custom/Extension/modules/Notes/Ext/Vardefs/custom_fields.php

whose entire contents is:

 <?php
  $dictionary['Note']['fields']['note_date'] = array(
        'required'      => '1',
        'name'          => 'note_date',
        'alias'         => 'hist_date',
        'vname'         => 'LBL_NOTE_DATE',
        'type'          => 'datetime',
        'default'       => date("m/d/Y H:i"),
        'massupdate'    => '0',
        'importable'    => 'true',
        'reportable'    => '1'
  );
?>  

The name of the file does not matter. Do a repair and the new field appears in the main notes table (not notes_cstm). You can then add it to layouts, etc through Studio.

The only additional problem was that the time inputs would not appear in the QuickCreate layout when I added my note_date field to Quick Create layout through Studio. To fix this I had to define the type in <sugarcrm>/custom/modules/metadata/quickcreatedefs.php with the line:

'type' => 'datetimecombo',

Phil

[grasshopper]

how come when I save a new record the stored datetime is 00/00/00 00:00:00? how do i save the input selected by the user or the value the controls have been set?

[datasponge]

It should save it correctly. If you set it in the UI, it should save that value. If you do not set it, it will set it to the default value defined in studio/vardefs.

If you did not set a default value and left it blank in Edit view, it might save it as all 0's. What I've seen in this case is that it then gets displayed as 1/1/2000 in Detail View. Go into studio and check how the default is set.

Also, did you define the fields using a vardefs extension or by adding a new field through studio?

Phil