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

[Alan Lord]

One other thing. Datetime columns in the database should ALWAYS be 
stored in UTC. They are converted as the user views them based on not 
only the format, but also their timezone.

Al

On 17/12/2024 17:40, Alan Lord wrote:
> I think I'd probably use a custom Event Handler rather than a workflow 
> and make the field read-only and update it directly using a query when 
> the triggering event occurs. You could add a simple test to say if the 
> field is not null or not empty, then don't update it - ever.
>
> HTH
>
> Al
>