Skip to main content
I understand that max/min do not work in the same manner for date/time fields as for numbers. Has anyone found a workaround this? I am bringing in some data over from Salesforce in a custom field in the Company object, and I want that field to stamp the most recent created date from all records in the source Salesforce object.





I'll really appreciate creative ideas here!



Hi Sarah,





Can you explain a little more about what you tried and ran into trouble on? If you wanted to find the most recent date by account in a specific source object, you can use the aggregation of Max on that date field in the fetch task. Only show the date field (aggregated to Max) and the Account ID though. This will return one record per Account ID that will be the most recent.





Then use a setup action rule to write that date to the custom field on the Company object.




Reply