Question

Workflow sorting Documents Incorrectly Based on Date

Workflow

Updated August 1, 2019

asked on August 1, 2019

My workflow is sorting the documents incorrectly. This only happens to some of the documents.

My condition is "If Request Date is between 07/01/2013 and 06/30/2014" go into "FY13-14"

But this condition is failing for some reason, and only on certain docs. For instance, a doc with a date of 01/02/2014 will go into the FY14-15 folder. This should go into the FY13-14. The FY14-15 is for anything between 07/01/2014 & 06/30/2015.

Does anyone know why this would be happening?

Thank you!

0 0

Answer

SELECTED ANSWER

replied on August 1, 2019

Hello Jason,

It looks like I have stumbled apron the solution myself.

I am pulling the date from the file name using regex. But, when I was pulling the date, I was storing it as a string. I simply changed it to store as a date, and it is working now.

It is always the simplest solution!

Thank you for trying to help!

1 0

Replies

replied on August 1, 2019

Where are you getting the documents dates from, and what does it show when you look at the condition evaluation in the workflow instance data?

1 0

SELECTED ANSWER

replied on August 1, 2019

Hello Jason,

It looks like I have stumbled apron the solution myself.

I am pulling the date from the file name using regex. But, when I was pulling the date, I was storing it as a string. I simply changed it to store as a date, and it is working now.

It is always the simplest solution!

Thank you for trying to help!

1 0

replied on August 1, 2019

That's exactly what I was suspecting lol. Gotta be extra attentive to those tags and I've had the same thing happen many times.

10 > 9 but... "9" > "10"

0 0

You are not allowed to follow up in this post.

Question

Question

Workflow sorting Documents Incorrectly Based on Date

Answer

Replies

Sign in to reply to this post.