Page 1 of 1

Finding Payment Due Date

PostPosted: Mon Apr 27, 2015 5:07 pm
by dorich
I want to locate the Payment Due Date on credit card invoices (pdf's).

I've been successful by using approaches like the first occurrence of the date. In this case I used "Contains Match", built the pattern using custom dates and selecting the pattern match to be the first in the document. However there are occasions where the due date does not appear as the first item and so the first date found is the invoice closing date.

To overcome this I tried making using a combination of finding content and pattern matching by creating a match that uses "Contains match" and then
"Payment Due Date (anything token)(month token)(anything token)(day token)(anything token)(year token)

But it appears that will not work. I'm assuming you can't add 'search text' to pattern matching?

Is there any way to pinpoint a specific date in a document other than counting from the beginning or the end of the document. Note also that for invoices where the Payment Due Date is omitted if no payment is due then the numerical order of the remaining dates changes so I think its likely that specifying the numerical order number of a date will not work unless you can guarantee that the content of the invoice never changes.

Any thoughts would be much appreciated.

Thanks.

Re: Finding Payment Due Date

PostPosted: Tue Apr 28, 2015 11:48 am
by Mr_Noodle
You can specify text. If it isn't working, it's probably more to do with your pattern itself. Plus, it doesn't look like you are using a custom date attribute there. You need to put all the month/day/year stuff in a custom date attribute if you want to capture that date to use later in your rule.

Re: Finding Payment Due Date

PostPosted: Fri May 01, 2015 3:25 pm
by dorich
Still having a problem with locating the "Payment Due Date" and its associated date.
I can find the text "Payment Due Date" and I can find a date using the date tokens but if I combine them in one statement or line then Hazel can't detect the elements I'm looking for and Hazel tells me that there is no rule associated with the file.

Currently my rule has two lines, the first identifies the account number and that works as expected.
The second line is written as
Code: Select all
Payment Due Date (anything token)(date token)


Where the date token is specified as:
Code: Select all
 (day token)(anything token)(month token)(anything token)(year token)

I've also tried:
Code: Select all
 (day token)/(month token)/(year token)


Any suggestions on what else I might try to get this working.

Thanks

Re: Finding Payment Due Date

PostPosted: Fri May 01, 2015 4:22 pm
by Mr_Noodle
I suggest you email support with an export of your rule and an example file.