Page 1 of 1

variable date format

PostPosted: Wed Aug 22, 2018 10:09 am
by Dan
Statements from one of my accounts use two different formats for the statement date. If the statement period spans two months the period will be given like this:
June 30, 2018 to
July 31, 2018

That is easy to parse, just grab the second occurance of a date. However, if the period is completely within a month it will be given like this:
July 1-31, 2018

Now it's the first date on the page rather than the second and also Hazel seems to have trouble with the date range (1-31).
I don't actually need the day of the statement, just the month and year. Is there any way to handle this situation?

Re: variable date format

PostPosted: Thu Aug 23, 2018 11:51 am
by Mr_Noodle
You might need to have two conditions. You can use a nested condition (search for them in the help) to do "any" for the date conditions.

As for matching the date range, you'll need to use a custom format (the automatic detection may not work properly in that case).