variable date format

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

Moderator: Mr_Noodle

variable date format 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?
Dan
 
Posts: 2
Joined: Sun Nov 19, 2017 5:00 pm

Re: variable date format 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).
Mr_Noodle
Site Admin
 
Posts: 11251
Joined: Sun Sep 03, 2006 1:30 am
Location: New York City


Return to Support