Skip to main content
sarah_kiani
sarah_kiani
Contributor ⭐️⭐️⭐️⭐️⭐️
November 29, 2018
Solved

Min/Max for dates

  • November 29, 2018
  • 1 reply
  • 541 views
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!

Best answer by dan_ahrens
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.

1 reply

dan_ahrens
dan_ahrensAnswer
Expert ⭐️⭐️⭐️
November 29, 2018
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.

VP of Customer Success at Forcepoint
    Terms & ConditionsAccessibility statement