Workflow condition with related entity on date field type doesn't save the date value #5020

New issue

Open

opened 2026-02-20 16:28:05 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 16:28:05 -05:00

Owner

Originally created by @re8260 on GitHub (May 24, 2023).

Issue

When you have condition on related entity on field of type date, condition will always fail because it save incorrect value and the date value will be removed from UI.

The selected date saved as string and can not be parsed letter
I will add example for Account and Call but it will work for any modules .
Don't check on fields Created and Modified date because it exists in all modules and will save correct

Expected Behavior

The value should be save as date

Actual Behavior

Date value should be saved as date

Possible Fix

Need to pas the related entity to function that parse value before save is

Steps to Reproduce

Crate new workflow on module Account (can be any other module)
In condition select related module I will use Calls (can be any other module) select date field, TYPE=VALUE and pick a date
Save workflow

Context

Your Environment

SuiteCRM Version used: Version 7.13.3
Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)):
Environment name and version (e.g. MySQL, PHP 7):
Operating System and version (e.g Ubuntu 16.04):

Context

Not possible to create conditions on date fields of related modules

Originally created by @re8260 on GitHub (May 24, 2023).     #### Issue When you have condition on related entity on field of type date, condition will always fail because it save incorrect value and the date value will be removed from UI. ![image](https://github.com/salesagility/SuiteCRM/assets/18328936/bbc9c33b-9a27-4e96-9e6e-432ab0a2f10d) The selected date saved as string and can not be parsed letter I will add example for Account and Call but it will work for any modules . Don't check on fields Created and Modified date because it exists in all modules and will save correct #### Expected Behavior The value should be save as date #### Actual Behavior Date value should be saved as date #### Possible Fix Need to pas the related entity to function that parse value before save is #### Steps to Reproduce   1. Crate new workflow on module Account (can be any other module) 2. In condition select related module I will use Calls (can be any other module) select date field, TYPE=VALUE and pick a date ![image](https://github.com/salesagility/SuiteCRM/assets/18328936/8579bcde-d0db-492f-8cb8-ea6cc16b850d) 3. Save workflow ![image](https://github.com/salesagility/SuiteCRM/assets/18328936/411eb4dc-90f6-47ce-ac49-b9e5240bf7d0) #### Context   #### Your Environment  * SuiteCRM Version used: Version 7.13.3 * Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): * Environment name and version (e.g. MySQL, PHP 7): * Operating System and version (e.g Ubuntu 16.04): #### Context Not possible to create conditions on date fields of related modules