Skip to main content
sarah_kiani
sarah_kiani
Contributor ⭐️⭐️⭐️⭐️⭐️
Nov 29, 2018 10:10 PM UTC
Solved

Min/Max for dates

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!

dan_ahrens
dan_ahrensAnswer
Expert ⭐️⭐️⭐️
Nov 29, 2018 10:48 PM UTC
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
View in thread

1 reply

dan_ahrens
dan_ahrensAnswer
Expert ⭐️⭐️⭐️
Nov 29, 2018 10:48 PM UTC
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.

Translate
VP of Customer Success at Forcepoint
    Terms & ConditionsAccessibility statement