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!
Page 1 / 1
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.
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
Sign up
If you ever had a profile with us, there's no need to create another one.
Don't worry if your email address has since changed, or you can't remember your login, just let us know at community@gainsight.com and we'll help you get started from where you left.
Else, please continue with the registration below.
Welcome to the Gainsight Community
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.