• DOCUMENTATION
  • WORKATO BLOG
  • PRODUCT BLOG
  • Return to Workato
  • Log in
  • ☰
  • Community/Discussions
New Topic
Discussions Recipe Building Formula Mode Questions
n

nimish.patel

started a topic about 4 years ago

Datapill value formatting

Hello All,


I'm trying to change the date format of the datapill called "Created Date" to match the format of the Datapill called "Close Date" so that I can then setup a conditional action to evaluate if those two datapill match/equal each other then do xyz.


Datapills in Salesforce:

  1. There's a datapill called Created Date. The value of that pill looks like this: 2018-03-14T22:51:13.000+00:00
  2. There's another datapill called Close Date. The value of that pill looks like this: 2018-03-14

Would anyone know how to go about doing that?

I've tried may different ways but I've failed to figure it out. I always end up with the output being "condition: false" where as I need it to be true and I'm assuming that whatever formula formatting I've tried with .to_date or .strftime("%Y-%m-%d") doesn't seem to be working. 

example:



3

 

If Salesforce Get related object list.Opportunity Field History Created Date.strftime("%Y-%m-%d") equals Salesforce New/updated object Close Date.strftime("%Y-%m-%d") then do



Please let me know if anyone needs more info or if they need me to post anything specific, appreciate the help in advance!

Patricia Guevarra

said about 4 years ago

Hi there,


Can you please send a link to the recipe you are working on?

Login to post a comment

Still can't find your solution?

Send us a ticket, we will try our best to assist you with your problem

Documentation
Developer's Library
Tutorials
eBooks
Product Hour
Product Blog
Workato Blog
Product updates
Customer Stories
© Workato 2020   Privacy   Terms   +1 (844) 469-6752
  • Documentation
  • Workato Blog
  • Product Blog
  • Solutions
  • Forums
  • Tickets
  • Log in
  • Return to Workato