Date Issue

[Alexgray25]

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

 

[aatalai]

import it as a string and then use datetimeparse formula

[Alexgray25]

Thanks for the reply, It seems to be coming in as a string already.

[aatalai]

try this

DateTimeAdd(ToDate('1900-01-01'),(tonumber([invoice date])-2),"days")

[csh8428]

@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

[rzdodson]

You can just nest the DateTimeAdd syntax within the original formula like so:

DateTimeAdd(DateTimeAdd('1900-01-01',ToNumber([Date]),'days'),-2,'days')