Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Error: The formula "Date" resulted in a integer but the field is a Date/Time

dmpope
8 - Asteroid

Hi everyone,

 

I have a formula that creates a date column in my workflow. This needs to be updated with a selected date via the Date interface tool on each run. 

 

The image won't upload, but I have the formula tool configured:

 

Output Column: Date

Formula: "2023-06-09"

Data Type: Date

 

And the Action tool:

 

Update Value (Default)

FormulaField - (at symbol)expression -value="2023-06-09"

Replace a Specific String is selected.

 

The way I have this set up works when I test it out with the interface on desktop designer but once I get it into Server it's giving me the error: The formula "Date" resulted in a integer but the field is a Date/Time. I've also tried changing the data type to Int64 and removing the quotations and it only returns the number 2008 in the Date field. 

 

I'm not really sure what I need to alter to get this to work properly within Server? I decided to crosspost this between Designer Desktop and Server boards since the problem lies with both.

 

Thank you

1 REPLY 1
geraldo
13 - Pulsar

@dmpope 

 

what you left selected in the action tool to be replaced has to be just the text 2023-06-09

 

date.JPG

 

Labels