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
