Pivot Output Field Not Recognized In Rule Actions

  • 1
  • Problem
  • Updated 4 days ago
Excuse the long post :) 

I used a pivot task on a dataset in bionic rules, pivoting on the field "Product Purchased" and outputting a date from the field Go Live Implementation:

I then confirmed that the results of this task are a list of dates for the go live of each product:

I therefore want to use this date field (12/12/1999 is just a default placeholder for time being) as a criteria to trigger a CTA but the field isn't being recognized as a date field, but rather as the values associated with the Product Purchased field that I had pivoted on:

I confirmed that the rule action is using the appropriate task output (called Merge 6):

Am I missing something here?  Am I unable to use the results of the pivot as criteria in my rule action?
Photo of Kate Green

Kate Green, Champion

  • 3,878 Points 3k badge 2x thumb

Posted 4 days ago

  • 1
Photo of Jitin Mehndiratta

Jitin Mehndiratta, Product Manager

  • 2,636 Points 2k badge 2x thumb
Hi Kate,

When I tried creating a similar rule in my test org, I was able to see date filters. Please see the attached screenshot. 
Can you share the source object name and also check the data type of the field "Go Live Implementation..."?  I suspect the data type is other than Date.

Photo of Kate Green

Kate Green, Champion

  • 3,836 Points 3k badge 2x thumb
Hi Jitin - thanks for your response.  The source of the data set is an SFDC custom object called "Products and Services Purchased" and I have confirmed that this is a date field:

What's strange is that the output that I exported to S3 does contain Date values in the fields.  It's just in the action criteria that it's not being recognized.