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

Question

Question

How can I find starting and ending week date from Barcode using QF

asked on April 28, 2017

Hello,

I have sticked multiple barcode on different document and extracting first 6 digits which represent date. I have extracted mm/dd/yy with the help of regualr expression.

My extracted result is 01/09/17. How can I find starting and ending week date. So that I can move document inside 01/09/17 thru 01/13/17 folder as shown in image. Please suggest.

Image

0 0

Replies

replied on April 28, 2017 Show version history

I do not know of an easy way in QF, but you can push your date into a field and store to an incoming temp folder.  Then set up a workflow to monitor that folder and let WF move the document to the correct folder.  Something like below should get you what you need.

First, we get the date from the field.  As I am writing this up, I notice that I should have put a Date Calculator here to create a token with a value of retrievefield_Date + 5 Days to populate FridayDate token in next step.  We then create DayOfWeek, MondayDate, and FridayDate tokens.  With the DayOfWeek token filled with the day of week from retrieved date, we enter a Repeat that is set to repeat as long as DayOfWeek does not equal Monday.  A Date Calculator then creates SearchMonday token by taking MonayDate - 1 day.  It also creates a new SearchFriday token by adding 5 days to it's SearchMonday token.  We then update the DayOfWeek, MondayDate, and FridayDate tokens with the values from our date calculator.  Finally, once we exit the Repeat, we can generate the Folder name.

Note that I did not run or test the above workflow, so you will have to test and tweek as needed.

0 0
replied on April 28, 2017

Thanks for the reply...

Does it possible using QF only.

0 0
replied on April 28, 2017

Do you have the QF scripting add-on?  You potentially could do it with that, but I have never used scripting in QF and with workflow, I dont see much need.  Quickfields does not have a Date Calculator, so there is not a built in way to add or subtract days from a date.

0 0
replied on May 1, 2017

Thank you. 

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

Sign in to reply to this post.