Rule cannot find 2nd or 3rd date

Get help. Get answers. Let others lend you a hand.

Moderator: Mr_Noodle

Rule cannot find 2nd or 3rd date Tue Jul 14, 2020 2:17 am • by rchrd
I've got a document (invoice) which has multiple dates in it. The first 2 dates are the billing period and the third is the billing date. I want to extract the last one to include that in the filename.

So in the document it looks like this:
Code: Select all
Billing Cycle    27-5-2020 to 26-6-2020
Invoice Date     14-7-2020


If I set the date matcher to automatic and first it matches the date 27-5-2020. But if I set it to 2nd or 3rd there is no match. Even when I set it to match the first date from the end it still matches the first one.

The preview of the rule shows this as (part of) the content:
Code: Select all
E0200AGEVZ 27-5-2020 to 26-6-2020 14-7-2020 Credit Card


Any ideas how I can extract the last date from the document.
rchrd
 
Posts: 2
Joined: Tue Jul 14, 2020 2:05 am

Re: Rule cannot find 2nd or 3rd date Tue Jul 14, 2020 10:01 am • by Mr_Noodle
I suggest specifying the date format explicitly in this case. Apple's data detectors in this case may not be able to deal with this correctly.
Mr_Noodle
Site Admin
 
Posts: 8621
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City

Re: Rule cannot find 2nd or 3rd date Tue Jul 14, 2020 3:07 pm • by rchrd
Thanks, setting the date format fixed the problem!
rchrd
 
Posts: 2
Joined: Tue Jul 14, 2020 2:05 am


Return to Support

cron