Question

Start Date - No End Date

Workflow Laserfiche Version 9

Updated November 7, 2014

asked on August 22, 2014

I know this is going to be a SUPER easy question... :-) I just can't for the life of me figure out how to search for it. I need to get the syntax for searching when I have a date range that includes a start date (when the dept started using LF), but no end date because they continue to put documents in. Basically I want any new documents to be checked.

Thanks much!

Toyia

0 0

Answer

SELECTED ANSWER

replied on August 22, 2014 • Show version history

Just remove the date, including the preceding comma. When you have removed , <="12/31/2012" what you are left with should be:

{[CAIS Document]:[Document Category]="02. Orders"} & {[CAIS Document]:[Temp Close Date]>="01/01/2010"}

0 0

Replies

replied on August 22, 2014

I feel slightly confused what you are asking for

1 0

replied on August 22, 2014

No problem! Here is the actual query:

{[CAIS Document]:[Document Category]="02. Orders"} & {[CAIS Document]:[Temp Close Date]>="01/01/2010", <="12/31/2012"}

I'm trying to get rid of the bolded information to leave it open ended and find all documents. Does that help??

0 0

SELECTED ANSWER

replied on August 22, 2014 • Show version history

Just remove the date, including the preceding comma. When you have removed , <="12/31/2012" what you are left with should be:

{[CAIS Document]:[Document Category]="02. Orders"} & {[CAIS Document]:[Temp Close Date]>="01/01/2010"}

0 0

replied on August 22, 2014

Yep, knew it was something super easy - just for the life of me today wouldn't come.

Thank you!

0 0

replied on November 6, 2014

I got to the point of testing this and it's not working quite as expected. I would also like to try to simplify it a little bit. Is there a way to put a search together to look for anything that is less than or equal to "today's date?" I've attached a screenshot of the current workflow. It's basically getting stuck at the "each entry" step, but I don't really need to have it look at everything - it really just needs to see if the "temp date" is less than or equal to today's date. Thanks much!

temp close date.docx (28.58 KB)

| Download

0 0

replied on November 6, 2014

Is that for the same Temp Close Date field? You can just add the second part of the search query back in an use the %(date) token instead of a fixed date.

1 0

replied on November 7, 2014

So, it should look like this?

{[CAIS Packet]} & {[CAIS Packet]:[Temp Close Date]>="01/01/2010", <="%(date)"} & {LF:LOOKIN="CAHS\Cases"}

This fails right now due to it being in an invalid format (invalid date format to be precise).

Thanks for your help!!

0 0

You are not allowed to follow up in this post.

Question

Question

Start Date - No End Date

Answer

Replies

Sign in to reply to this post.