AnsweredAssumed Answered

maxRelatedDate - What am I doing incorrectly?

Question asked by Bud Hartley on Jan 8, 2017
Latest reply on Oct 5, 2017 by Patrick McQueen

I want a date field in the Accounts Module that reflects the date of the last Call recorded.  I have a simple process that captures the date of a new call, but I'm thinking the maxRelatedDate would do this for me.  I've tried the following four options, but they are putting a date that is usually one day before the actual last call, and the timestamp seems to be 4:00 PM or 5:00 PM in all four fields.


Last Call Date Created:  maxRelatedDate($calls,"date_entered")

Last Call Date Modified: maxRelatedDate($calls,"date_modified")

Last Call Date Recorded: maxRelatedDate($calls,"call_recorded_date_c")

Last Call Date Start: maxRelatedDate(related($calls,"date_start")


My simple process updates another field with: “Call Recorded Date” but that only addresses new or modified call records.