|
Hyrule19190 Posts
I needed to make sure dates were in Y-m-d format for some calculations at work, so I wrote this up. It's not perfect, but it's quite enough to handle my needs. So, for anyone who uses PHP and needs to make sure dates are in Y-m-d format (for strtotime() or whatever reason), I grant you checkDateFormat(). It checks for valid formatted dates with space, hyphen, period, or slash separation.
function checkDateFormat($date, $empty = '0', $sep = '/')
{
$date = preg_replace('/[^\d\-\. \/]/', '', $date); // remove non-numeric and non-date separaters
$check = preg_split('/[ \-\.\/]/', $date);
if(empty($check)) return '0';
foreach($check as &$item)
$item = str_pad($item, 2, '0', STR_PAD_LEFT);
$date = implode('-', $check);
// matches for all format dates, with space, hyphen, period, or slash separators
// correct format needed is Y-m-d
// 100 is used as the final check to keep room open for later additions
$patterns = array(
0 => '/(9999)[- \.\/](09)[- \.\/](09)/', // one of the many different "blank" values used
1 => '/(0[1-9]|1[012])[- \.\/](0[1-9]|1[012])[- \.\/](\d{4,4})/', // unknown d-m order, Y at end
2 => '/(\d{4,4})[- \.\/](0[1-9]|1[012])[- \.\/](0[1-9]|1[012])/', // unknown d-m order, Y at front
3 => '/(0[1-9]|1[012])[- \.\/](0[1-9]|[12][0-9]|3[01])[- \.\/](\d{4,4})/', // m-d-Y
4 => '/(\d{4,4})[- \.\/](0[1-9]|1[012])[- \.\/](0[1-9]|[12][0-9]|3[01])/', // Y-m-d (aka already correct)
5 => '/(0[1-9]|[12][0-9]|3[01])[- \.\/](0[1-9]|1[012])[- \.\/](\d{4,4})/', // d-m-Y
6 => '/(\d{4,4})[- \.\/](0[1-9]|[12][0-9]|3[01])[- \.\/](0[1-9]|1[012])/', // Y-d-m
99 => '/ |[s(\302\240|\240)]+|[W]+/', // blank, empty, or placeholder
100 => '/(\d{2,2})[- \.\/](\d{2,2})[- \.\/](\d{2,2})/' // unknown all double digits
);
// for unknown d-m order assume month is first
$replace = array(
0 => $empty,
1 => "$3{$sep}$1{$sep}$2", // unknown d-m order, Y at end -> Y-m-d
2 => "$1{$sep}$2{$sep}$3", // unknown d-m order, Y at front -> Y-m-d
3 => "$3{$sep}$1{$sep}$2", // m-d-Y -> Y-m-d
4 => "$1{$sep}$2{$sep}$3", // Y-m-d -> Y-m-d
5 => "$3{$sep}$2{$sep}$1", // d-m-Y -> Y-m-d
6 => "$3{$sep}$1{$sep}$2", // Y-d-m -> Y-m-d
99 => "$0",
100 => $empty
);
foreach($patterns as $index => $pattern)
if(preg_match($pattern, $date))
return preg_replace($pattern, $replace[$index], $date);
return $empty;
}
Yeah, the regular expressions are long, but whatever. I replaced tabs with 2 spaces because it was huge (I develop with tabstop = 4, but the most common setting is 8, which is ugly).
if you want to return the original date, change $replace as follows:
100 => "$1-$2-$3"
Easy, eh?
I'll explain it more thoroughly later (ie: when I'm not at work) if anyone wants me to.
[update]
Added in checks for single digits (again, my users cannot be trusted!) and some other checks
|
Yea, that looks right......
|
More like "Regex - Date Format Check"
|
|
|
Hyrule19190 Posts
On July 21 2010 01:46 Dance.jhu wrote:
Yea, that looks right......
^^
On July 21 2010 01:50 Cambium wrote:
More like "Regex - Date Format Check"
Nah. Regex is a way of expressing patterns, you still need Perl/PHP/somelanguagethathandlesregex to use them. But yeah, it's more regex than PHP :X
On July 21 2010 02:00 gen.Sun wrote:
stackoverflow.com
Is that a nice way of saying "gtfo"?
|
What is the context of this solution - where's the data coming from? If you can't assume users are entering dates in just one format, then you can't assume they're not going to put the day the day before the month in all ambiguous dates. The clear problem here is the lack of disambiguation with m-d/d-m dates.
|
Hyrule19190 Posts
True, but the data is coming from America (not really what you asked, but eh?), so dates are typically m-d-Y.
As for who's entering it, right now there's only a few people in our office, but this project will be sold to others. My code (elsewhere) checks the whole ambiguous date thing in other ways.
|
There's not really a need for such complicated logic. strtotime accepts any english date format so you could use something like:
$time = strtotime($date);
if ($time < 0) throw new Exception("Invalid Date Format: $date");
return date('Y-m-d', $time);
If you're running PHP 5.2 or newer, you can also use the DateTime class.
return new DateTime($date); // throws an exception if your date is invalid
|
I don't see why checkdate() wouldn't work for this if you expect the arguments in a certain order. This seems like more of an input problem than a parsing problem.
|
The dates are presumably in text... only reason you would do this
|
On July 21 2010 02:38 tofucake wrote:Is that a nice way of saying "gtfo"?
It's just a better place to ask programming questions, it'll be both faster and better.
|
aers
United States1210 Posts
He's not asking a question, though.
|
Hyrule19190 Posts
On July 21 2010 04:58 Pryce wrote:There's not really a need for such complicated logic. strtotime accepts any english date format so you could use something like: $time = strtotime($date); if ($time < 0) throw new Exception("Invalid Date Format: $date"); return date('Y-m-d', $time); If you're running PHP 5.2 or newer, you can also use the DateTime class. return new DateTime($date); // throws an exception if your date is invalid
strtotime() is used, but it doesn't accept any format. This is used for financial transactions (well, displaying them..thousands of them), so a bunch of "Invalid Date Format: $date" displays is not acceptable.
On July 21 2010 05:04 R1CH wrote:I don't see why checkdate() wouldn't work for this if you expect the arguments in a certain order. This seems like more of an input problem than a parsing problem.
The people inputting the dates cannot be trusted.
On July 21 2010 10:14 gen.Sun wrote:Show nested quote +On July 21 2010 02:38 tofucake wrote:On July 21 2010 02:00 gen.Sun wrote:
stackoverflow.com Is that a nice way of saying "gtfo"? It's just a better place to ask programming questions, it'll be both faster and better. I'm not asking a question, I'm posting a solution to a possible question. Also, I literally just forgot what I was going to say.
|
On July 21 2010 21:02 tofucake wrote:Show nested quote +On July 21 2010 04:58 Pryce wrote:There's not really a need for such complicated logic. strtotime accepts any english date format so you could use something like: $time = strtotime($date); if ($time < 0) throw new Exception("Invalid Date Format: $date"); return date('Y-m-d', $time); If you're running PHP 5.2 or newer, you can also use the DateTime class. return new DateTime($date); // throws an exception if your date is invalid strtotime() is used, but it doesn't accept any format. This is used for financial transactions (well, displaying them..thousands of them), so a bunch of "Invalid Date Format: $date" displays is not acceptable.
See, I just assumed that you were working with large blocks of text, because otherwise regular expressions are one of the worst ways to solve this problem. strtotime() will work with any of the date formats you test for, and will make the same assumption your code does for ambiguous month/day formats. But whatever floats your boat.
|
Hyrule19190 Posts
Yeah I was using just strtotime() before, and it was returning 0 for about half the dates. When I started using my version, all the dates are formatted correctly (and all the calculations are correct).
|
Hyrule19190 Posts
Shameless bump! I updated my original with a few more checks. Works better since I found some more formats in the database :|
|
konadora
Singapore66358 Posts
|
Hyrule19190 Posts
It's really not. Most of that is actually Perl (which is very difficult to read if you're not used to it). The only reason I do something this complicated is because I didn't write the original stuff, and that allowed for (and does) a lot of dumb things.
|
Is this for users to enter dates into a text box and then you check it? If so why go through this if you can just restrict the users from using text boxes and just have drop down boxes or a calendar of some sort. That way you never need to worry about bad user inputs. Its usually better to just not allow users the freedom to do anything they want because they can and WILL break it.
|
Hyrule19190 Posts
Because there are already thousands upon thousands of dates in the database. I didn't write the original site, I've come in to fix it.
|
|
|
|
|
|
EPT
