Hi,
I am working on new workflow and the date does not seem to be configured when it enters the workflow.
It goes in as below.
However comes into the workflow like this, and whatever I do I cant format it correctly.
Any help would be appreciated.
Thanks
Alex
import it as a string and then use datetimeparse formula
Thanks for the reply, It seems to be coming in as a string already.
try this
DateTimeAdd(ToDate('1900-01-01'),(tonumber([invoice date])-2),"days")
@Alexgray25 Try this. It creates a new field that is formatted as a date; however, the value is 9/27/2023, not 9/25/2023. If you need it to equal 9/25 then just add a new formula tool using DateTimeAdd(or put it right in the Multi-Field formula tool in the workflow).
If this works for you please mark it as solved and add a like.
Thanks,
Craig
You can just nest the DateTimeAdd syntax within the original formula like so:
DateTimeAdd(DateTimeAdd('1900-01-01',ToNumber([Date]),'days'),-2,'days')