Skip to main content
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?
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.








Regards,


Jitin
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.
Hi Jitin - can you think of any ideas here?  I have followed up with support but haven't heard anything back.
Hey Kate, I am escalating the ticket internally so we can get some answers here. Sorry for the delay. 
Hi Kate, Sorry for the inconvenience, there is no workaround for this issue. Our engineering team has accepted this as bug,will update you here once this is fixed.





Thanks for bringing this.
Hi Kate,  I recently started going through all of the unanswered or unresolved problems and questions here. Was checking to see if this has been resolved or if it is an ongoing issue?
Hi Sai - yes, support addressed this issue and I was able to complete the configuration of my rule.  Thanks!

Reply