Date Input Issue with user Interface

[tlhoyt]

I am receiving an error "The formula "Date" resulted in a number but the field is a Date/Time." error in the attached workflow when running as an Analytic App. Any suggestions on how to fix this? 

[JamesCharnley · Accepted solution]

Hi @tlhoyt 

In this instance the reason that you're getting that error is that your action tool is set to replace the entire formula - the date value being passed in is not a value that's wrapped in quotes, so the data type doesn't match. The below pictures demonstrate what the formula would like when the app is run, and also how the value should correctly be formatted as a date.

You can eliminate this error by choosing to only replace a specific part of the string in the action tool with the check box at the bottom of the configuration pane, and only replacing the date value in the formula, like so:

This will eliminate the error and work as intended by only replacing the value within the formula. However, the date tool will pass a correctly formatted date value into the formula so it shouldn't need to be Datetimeparsed either, rendering the formula somewhat unnecessary in this instance.