• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 03:39
CEST 09:39
KST 16:39
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
TL.net Map Contest #21: Voting10[ASL20] Ro4 Preview: Descent11Team TLMC #5: Winners Announced!3[ASL20] Ro8 Preview Pt2: Holding On9Maestros of the Game: Live Finals Preview (RO4)5
Community News
Chinese SC2 server to reopen; live all-star event in Hangzhou14Weekly Cups (Oct 13-19): Clem Goes for Four0BSL Team A vs Koreans - Sat-Sun 16:00 CET6Weekly Cups (Oct 6-12): Four star herO85.0.15 Patch Balance Hotfix (2025-10-8)80
StarCraft 2
General
Chinese SC2 server to reopen; live all-star event in Hangzhou RotterdaM "Serral is the GOAT, and it's not close" Weekly Cups (March 17-23): Clem Bounces Back DreamHack Open 2013 revealed The New Patch Killed Mech!
Tourneys
$1,200 WardiTV October (Oct 21st-31st) SC2's Safe House 2 - October 18 & 19 INu's Battles #13 - ByuN vs Zoun Tenacious Turtle Tussle Sparkling Tuna Cup - Weekly Open Tournament
Strategy
Custom Maps
Map Editor closed ?
External Content
Mutation # 496 Endless Infection Mutation # 495 Rest In Peace Mutation # 494 Unstable Environment Mutation # 493 Quick Killers
Brood War
General
Is there anyway to get a private coach? BW General Discussion BGH Auto Balance -> http://bghmmr.eu/ BSL Season 21 OGN to release AI-upscaled StarLeague from Feb 24
Tourneys
300$ 3D!Community Brood War Super Cup #4 [ASL20] Semifinal B Azhi's Colosseum - Anonymous Tournament [Megathread] Daily Proleagues
Strategy
Current Meta Roaring Currents ASL final [I] Funny Protoss Builds/Strategies BW - ajfirecracker Strategy & Training
Other Games
General Games
Path of Exile Nintendo Switch Thread Stormgate/Frost Giant Megathread Dawn of War IV ZeroSpace Megathread
Dota 2
Official 'what is Dota anymore' discussion LiquidDota to reintegrate into TL.net
League of Legends
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Deck construction bug Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread SPIRED by.ASL Mafia {211640}
Community
General
Things Aren’t Peaceful in Palestine The Chess Thread US Politics Mega-thread Russo-Ukrainian War Thread Men's Fashion Thread
Fan Clubs
The herO Fan Club!
Media & Entertainment
Anime Discussion Thread Series you have seen recently... [Manga] One Piece Movie Discussion!
Sports
2024 - 2026 Football Thread TeamLiquid Health and Fitness Initiative For 2023 MLB/Baseball 2023 Formula 1 Discussion NBA General Discussion
World Cup 2022
Tech Support
SC2 Client Relocalization [Change SC2 Language] Linksys AE2500 USB WIFI keeps disconnecting Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List Recent Gifted Posts
Blogs
Our Last Hope in th…
KrillinFromwales
Certified Crazy
Hildegard
The Heroism of Pepe the Fro…
Peanutsc
Rocket League: Traits, Abili…
TrAiDoS
Customize Sidebar...

Website Feedback

Closed Threads



Active: 1062 users

PHP - Date Format Check

Blogs > tofucake
Post a Reply
Normal
tofucake
Profile Blog Joined October 2009
Hyrule19144 Posts
Last Edited: 2010-07-23 14:31:29
July 20 2010 16:15 GMT
#1
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

Liquipediaasante sana squash banana
Dance.jhu
Profile Blog Joined May 2010
United States292 Posts
July 20 2010 16:46 GMT
#2
Yea, that looks right......
It is what it is...
Cambium
Profile Blog Joined June 2004
United States16368 Posts
July 20 2010 16:50 GMT
#3
More like "Regex - Date Format Check"
When you want something, all the universe conspires in helping you to achieve it.
gen.Sun
Profile Blog Joined October 2009
United States539 Posts
July 20 2010 17:00 GMT
#4
stackoverflow.com
tofucake
Profile Blog Joined October 2009
Hyrule19144 Posts
Last Edited: 2010-07-20 17:39:13
July 20 2010 17:38 GMT
#5
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"?
Liquipediaasante sana squash banana
Louder
Profile Blog Joined September 2002
United States2276 Posts
July 20 2010 18:59 GMT
#6
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.
tofucake
Profile Blog Joined October 2009
Hyrule19144 Posts
July 20 2010 19:06 GMT
#7
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.
Liquipediaasante sana squash banana
Pryce
Profile Joined February 2009
Canada7 Posts
Last Edited: 2010-07-20 20:05:31
July 20 2010 19:58 GMT
#8
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
R1CH
Profile Blog Joined May 2007
Netherlands10341 Posts
July 20 2010 20:04 GMT
#9
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.
AdministratorTwitter: @R1CH_TL
Louder
Profile Blog Joined September 2002
United States2276 Posts
July 20 2010 23:42 GMT
#10
The dates are presumably in text... only reason you would do this
gen.Sun
Profile Blog Joined October 2009
United States539 Posts
July 21 2010 01:14 GMT
#11
On July 21 2010 02:38 tofucake wrote:
Show nested quote +
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.
aers *
Profile Joined January 2009
United States1210 Posts
July 21 2010 02:18 GMT
#12
He's not asking a question, though.
tofucake
Profile Blog Joined October 2009
Hyrule19144 Posts
July 21 2010 12:02 GMT
#13
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.
Liquipediaasante sana squash banana
Louder
Profile Blog Joined September 2002
United States2276 Posts
July 21 2010 16:49 GMT
#14
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.
tofucake
Profile Blog Joined October 2009
Hyrule19144 Posts
July 21 2010 19:55 GMT
#15
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).
Liquipediaasante sana squash banana
tofucake
Profile Blog Joined October 2009
Hyrule19144 Posts
July 23 2010 14:32 GMT
#16
Shameless bump! I updated my original with a few more checks. Works better since I found some more formats in the database :|
Liquipediaasante sana squash banana
konadora *
Profile Blog Joined February 2009
Singapore66355 Posts
July 23 2010 14:43 GMT
#17
php looks hard ;;
POGGERS
tofucake
Profile Blog Joined October 2009
Hyrule19144 Posts
July 23 2010 16:06 GMT
#18
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.
Liquipediaasante sana squash banana
Dycedarg
Profile Joined July 2010
United States12 Posts
July 23 2010 18:16 GMT
#19
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.
tofucake
Profile Blog Joined October 2009
Hyrule19144 Posts
July 23 2010 18:19 GMT
#20
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.
Liquipediaasante sana squash banana
Dycedarg
Profile Joined July 2010
United States12 Posts
July 23 2010 18:28 GMT
#21
The database doesn't follow a standard date format? That just sounds horrible...
tofucake
Profile Blog Joined October 2009
Hyrule19144 Posts
July 23 2010 20:09 GMT
#22
Yeah. "Date" fields are all varchar(12)'s.
Liquipediaasante sana squash banana
Pryce
Profile Joined February 2009
Canada7 Posts
Last Edited: 2010-07-24 05:08:38
July 24 2010 05:03 GMT
#23
On July 24 2010 03:19 tofucake wrote:
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.


You should fix the dates in the database, and change the schema to use the SQL date type for columns that are meant to store dates. The database will then constrain your inputs and outputs to be sane values (which may require some input validation logic). After that's in place, you can throw the date fixing script away, as that's the type of code that shouldn't live in production code. You'll have a hell of a time unit testing it.
Count9
Profile Blog Joined May 2009
China10928 Posts
Last Edited: 2010-07-24 06:30:14
July 24 2010 06:24 GMT
#24
I just add a MM/DD/YYYY thing next to every date entry box and write one regex to check if it's valid, just seems to make more sense.

Oh, it's already in the database LOL, that sucks. Though I'm sure there's already a date parser somewhere.

Also,
// for unknown d-m order assume month is first
is really sketchy >.>

Also also, it's generally better to just parse the date with regex then use another process to check whether the date is valid (e.g. not 99-99-9999) cause it's not very efficient to use so many alternations, which makes the regex engine backtrack quite a bit.
Cambium
Profile Blog Joined June 2004
United States16368 Posts
July 24 2010 06:35 GMT
#25
On July 24 2010 14:03 Pryce wrote:
Show nested quote +
On July 24 2010 03:19 tofucake wrote:
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.


You should fix the dates in the database, and change the schema to use the SQL date type for columns that are meant to store dates. The database will then constrain your inputs and outputs to be sane values (which may require some input validation logic). After that's in place, you can throw the date fixing script away, as that's the type of code that shouldn't live in production code. You'll have a hell of a time unit testing it.


Agreed completely, especially the production code point; this piece of code will be a nightmare to maintain down the road. I'd put the check at the php level or even JS level instead of relying on the db to throw exceptions.

The whole thing just seems completely unnecessary. After all, user stupidity is unbound, and you can't check for everything.
When you want something, all the universe conspires in helping you to achieve it.
tofucake
Profile Blog Joined October 2009
Hyrule19144 Posts
July 24 2010 12:41 GMT
#26
I have the date check function because my current assignment is to fix a particular page. Once that's done I'll have a new assignment, and I'm going to be pushing for that to be to fix some things in the database (like dates! but there are bigger problems), and then move the check from being used tens of thousands of times in processing to once to validate input before it's stored.
Liquipediaasante sana squash banana
Normal
Please log in or register to reply.
Live Events Refresh
Next event in 2h 21m
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
SortOf 110
StarCraft: Brood War
Aegong 68
ToSsGirL 48
Mong 1
Dota 2
XaKoH 212
XcaliburYe123
canceldota63
League of Legends
JimRising 695
Counter-Strike
Stewie2K614
Coldzera 283
shoxiejesuss261
Other Games
summit1g7312
WinterStarcraft408
ceh9400
Tasteless167
Hui .108
Mew2King76
Trikslyr15
Organizations
Other Games
gamesdonequick764
Counter-Strike
PGL249
Other Games
BasetradeTV72
StarCraft: Brood War
UltimateBattle 30
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 15 non-featured ]
StarCraft 2
• LUISG 23
• intothetv
• AfreecaTV YouTube
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• WagamamaTV530
League of Legends
• Lourlo1203
• Jankos1042
• Stunt686
Upcoming Events
Replay Cast
2h 21m
OSC
8h 21m
Tenacious Turtle Tussle
15h 21m
The PondCast
1d 2h
OSC
1d 4h
WardiTV Invitational
2 days
Online Event
2 days
RSL Revival
2 days
RSL Revival
3 days
WardiTV Invitational
3 days
[ Show More ]
Afreeca Starleague
4 days
Snow vs Soma
Sparkling Tuna Cup
4 days
WardiTV Invitational
4 days
CrankTV Team League
4 days
RSL Revival
4 days
Wardi Open
5 days
CrankTV Team League
5 days
Replay Cast
6 days
WardiTV Invitational
6 days
CrankTV Team League
6 days
Liquipedia Results

Completed

Acropolis #4 - TS2
WardiTV TLMC #15
HCC Europe

Ongoing

BSL 21 Points
ASL Season 20
CSL 2025 AUTUMN (S18)
C-Race Season 1
IPSL Winter 2025-26
EC S1
Thunderpick World Champ.
CS Asia Championships 2025
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual

Upcoming

SC4ALL: Brood War
BSL Season 21
BSL 21 Team A
BSL 21 Non-Korean Championship
RSL Offline Finals
RSL Revival: Season 3
Stellar Fest
SC4ALL: StarCraft II
CranK Gathers Season 2: SC II Pro Teams
eXTREMESLAND 2025
ESL Impact League Season 8
SL Budapest Major 2025
BLAST Rivals Fall 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2025 TLnet. All Rights Reserved.