[Vtigercrm-developers] Has anyone else had a problem with a user's date format preference interfered with a custom datetime field?

[Alexander Allen]

Hello. I also use custom field date on Help Desk module. I found similar
uses as you. To fix it I set that fields to not display on edit mode (In
the vtiger_field table change display time from 1 to 2 or 3, don’t
remeber). Also I put the UITYPE as 1 and let Date time as format.

If this also not works, change your table vtiger_ticketcf field forme date
time to varchar. If you this, get a backup of your table if something does
not work.

I remember that the main key is to not show the field in the Edit Mode.




On Fri, Dec 20, 2024 at 04:37 Alan Lord <alanslists at gmail.com> wrote:

> vtiger open source doesn't really have an "editable" datetime field
> UIType. The one used for Modified and Created time values is really only
> a read-only field type.
>
> I had to create a custom UItype field for one customer who really wanted
> an editable datetime field. You will also need a different UX library to
> let you edit it in Detail and Edit Views. FWIW I used a small library
> called FlatPickr. Honestly it was a right PITA and took me ages to get
> all the possible ways a user could edit/view it to work properly in
> multiple timezones.
>
>
> Al
>
>
> On 19/12/2024 23:02, Steve Kenow wrote:
> > Login and set calendar preferences to mm-dd-yyyy
> > Navigate to a closed ticket
> > Edit - make no changes
> > Save
> >
> > Result: Closed Date (cf_825) is saved as 0000-00-00 00:00:00
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20241220/4f18e31e/attachment.html>