Set Date field with Todays Date

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Good Afternoon,

Quick question, is there a non-code related method (maybe workflow/formula/etc) to set a date field to "Today's Date" when a specific field is modified? For example:

Custom Date Field: ABC Field Last Modified Date
Custom Drop-Down: ABC Field

When ABC field is changed to ANY value, I just want it to capture the current date in the ABC Field Last Modified date. Essentially, this is simply to track the last time this specific field was modified.

Any assistance you could give would be greatly appreciated. Thanks in advance!

2

Yes I think you do that with a Workflow. Off the top of my head, it should look something like this:

  • On save

  • On modified records

  • condition: ABC field “equal to” “any change”

  • action: calculated fields, no parameters, add formula for “ABC Field Last Modified Date”, something like {now(Y-m-d H:i:s)}

See https://docs.suitecrm.com/user/advanced-modules/workflow-calculated-fields/ for details.

3

PGR,

You were 100% right. It was formula I was missing. Thank you very much for the link, I don’t know why I didn’t come across that in my search. All is good, workflow is working like a charm. Thanks again!