Error in Tool

[Srawat]

Hi,

Can anyone help me resolve the below error. I am attaching the WF. 

Thanks,

[PanPP]

Hi @Srawat 

I would make sure the following column FY23 is in a date datatype format. 

This should resolve your issue. 

[Srawat]

the columns are in V_string. format and when I split and make separate WF then It's working fine. 

[PanPP]

When using the analytic app functionality, all date inputs that are fed into the formula/filter tools will need to be date data type.

[Srawat]

Thanks for your support. All the things were fine in WF. I have checked again and see the problem was in action tool. I have not check marked in bottom replace options. Now the issue resolve.

[PanPP · Accepted solution]

Hi @Srawat 

Awesome.. you were able to resolve the issue by using the replace string option at the bottom of the action tool..