Using Date Tool on a simple workflow

[yhct1lg]

Hello, new to Alteryx. Just learned about this community and been looking at different solutions offered here. You guys are amazing. 

So, yesterday I had this issue "The formula "Date" resulted in a number but the field is a Date/Time. (Expression #1)"

Funny thing is, this was asked in this forum by another user last year in this thread - 

Solved: Update date using Date Tool - Alteryx Community

I tried the suggested solution but it still doesn't work and I'm getting the same error. What am I missing or what did I do wrong?

It is to be noted that - this formula is applied in a macro and when I run the macro separately, I'm not getting any error. But when the execution comes back to the main workflow - it's throwing me an error saying there's an error in the macro date function.

[messi007]

@yhct1lg,

About the error when you run the macro is because the data inputed out side of the macro are differente from the data used in the macro that's why you don't have error when you run the macro alone. Could you share the macro  with a sample data used as input it will help to investigate and give you the solution.

Best regards,

[yhct1lg]

@messi007 Attaching the macro and a sample input

[ArtApa]

Hi @yhct1lg - The issue is in your action tool. You need to reconfigure it:

1) Replace a specific string

2) Remove quotes

It will then run fine: