In Process Author, what would be a good way to compare two dates?
For example, the criteria is that Modified Date is after Created Date?
True. My recommendation would require a re-save on all the records to recalculate those values on a daily basis, which is not a good option. It looks like there may need to be some code-level customizations that need to occur here in order to perform this task.
Hi Lori Arce - I guess I should file a feature request on this?
One thought is that you may be able to do this by creating a custom field that adds the days between the two dates, then filter on that custom field. I haven't tested this out yet and won't be able to until later today, but thought I would mention it if you wanted to play around with the idea until then.
To answer your question, yes, this would be a feature request. I do not see one for this type of request submitted to our Products team yet.
Good idea but I will probably run into trouble with a calculated field since it is only update when the record is updated (see --> https://community.sugarcrm.com/thread/27047 ) ?
Meaning, the update of a calculated field is contingent on the record being saved/updated rendering the whole idea useless. Or am I thinking this too narrow?
Thanks though for looking into this
It does look like a Feature Request will need to be created. If you haven't done so already, please submit a request to support.
Thanks, done & done -> https://web.sugarcrm.com/support/cases/c8940d03-fc05-2ccf-8859-571797d2a4fb
Retrieving data ...