PA: Date field is after another date field

Hi Lori F - I guess I should file a feature request on this?

Kristjan,

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.

Lori

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, KGM

Kristjan,

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.

Kind Regards,

Lori

Thanks though for looking into this

KGM

Thanks though for looking into this

KGM

Kristjan,

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.

Lori

Thanks, done & done -> https://web.sugarcrm.com/support/cases/c8940d03-fc05-2ccf-8859-571797d2a4fb