You are viewing limited content. For full access, please sign in.

Question

Question

Invalid Date Value message from Workflow, what format is it looking for

asked on June 21, 2017 Show version history

I keep getting the message that 6/21/2017 or any valid date format is invalid from Workflow when using date functions. For example I am trying to run the function NETWORKDAYS from the Token Calculator activity and it says that 6/20/2017 is an invalid date format. What format is it looking for? That is a perfectly valid date format and that is the date format that workflow uses whenever I ask it for a date.

Here is the full error message

    6/20/2017 3:36:16 PM    Calculate dates between start and import     Invalid Date Value:  Function: NETWORKDAYS Expression: NETWORKDAYS(%(Start Date) ,%(Import Date) ) Message: 6/20/2017

0 0

Answer

SELECTED ANSWER
replied on June 27, 2017

It works for me in 10.2. Is your Import Date token tagged as being a date?

1 0

Replies

replied on June 27, 2017

Well I am pretty sure the token calculator activity just does not work anymore, something went wrong with it in 10.2. Going to have to use scripts to replace the functions in this activity.

0 0
SELECTED ANSWER
replied on June 27, 2017

It works for me in 10.2. Is your Import Date token tagged as being a date?

1 0
replied on June 27, 2017

Oh I never knew thats what tags are for. Somehow I have gotten by all this time with the string tag. Setting the tag to Date fixed the issue. Thanks! It's like declaring a variable then.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.