Paste a list of dates and every one is reformatted at once. This page turns MM/DD/YYYY into YYYY-MM-DD, the ISO 8601 order that sorts correctly as plain text. It uses one pattern rule you can adjust for any order, and it runs entirely in your browser.
The tool above uses a single pattern rule: capture the three numbers, then output them in the order you want.
Find (pattern): (\d{1,2})/(\d{1,2})/(\d{4})
Replace with: $3-$1-$2
MM/DD/YYYY -> YYYY-MM-DD (used above)
Same idea, other orders:
DD/MM/YYYY -> YYYY-MM-DD : replace with $3-$2-$1
YYYY-MM-DD -> DD/MM/YYYY : find (\d{4})-(\d{2})-(\d{2}), replace $3/$2/$1$1, $2 and $3 are the three captured numbers. Reorder them however your target format needs.
Putting the year first (YYYY-MM-DD) means dates sort chronologically as plain text, which is why databases, logs and file names prefer it.
Every line that matches the pattern is converted in one pass, so you can paste a column of dates and reformat them all at once.
Swap the $1, $2 and $3 in the replacement to output day, month and year in whatever order your target expects.
Download this exact setup as a ready-made Date to ISO profile. Give it a global hotkey in the Windows app and any list of dates you copy is reformatted the instant you paste. Same engine as above, entirely offline.
Paste your dates above and each MM/DD/YYYY date becomes YYYY-MM-DD instantly. The tool uses one pattern rule you can copy, or export as a profile for the Windows app.
Reorder the capture groups in the replacement: $1 is the first captured number, $2 the second and $3 the third, so $3-$1-$2 gives year, month, day.
YYYY-MM-DD is the ISO 8601 standard and it sorts in date order when treated as plain text, unlike MM/DD/YYYY. It also avoids the confusion between US and European day and month order.
More generators: GUIDs, date formats, random strings and today's date.
Remove Special Characters