Update date using Date Tool

[NidhiAg]

I am trying to something really simple. I have a date column and I am trying to replace is dynamically using Date and action tool. But I am getting error Formula (9): The formula "Date" resulted in a number but the field is a Date/Time. (Expression #1)
  

What am i doing wrong

[Emil_Kos]

---

@NidhiAg wrote:

I am trying to something really simple. I have a date column and I am trying to replace is dynamically using Date and action tool. But I am getting error Formula (9): The formula "Date" resulted in a number but the field is a Date/Time. (Expression #1)
  

What am i doing wrong

---

Can you Check If your date formula is working correctly? It seems that you got an error on it. Check the data type od this column as it seems that is the issue.

[Maskell_Rascal · Accepted solution]

Hey @NidhiAg 

So the problem actually has to do with how the formula tool reads dates. 

To add a date manually in the Formula tool, we have to treat it like a string with using quotes with the data type set to Date. 

What happens when you use the Date interface tool is that the system treats your selection as a string/numeric value being transferred into the Formula tool. 

There are numerous ways to fix this, but the simplest way is to hard code a date into your Formula date field like this:

Then configure your Action tool like this:

I've attached an analytic app that has a three different methods for you to try out. 

Let me know if any of these work for you. 

Thanks!

Phil

[NidhiAg]

 Thank you so much it works perfect...

[yhct1lg]

I'm facing the same error even after changing it to the string like suggested. Could you help me out? 
Using Date Tool on a simple workflow - Alteryx Community