Is 03/04 March or April? Make AI flag it, not guess.
The request most people type
Tested in GPT-5.5 (OpenAI API), Oct 2026
Here is a shared sheet from a New York and a London team, with eight fictional bookings. Three of the dates, like 03/04/2027, can be read two ways. This is the usual request.
One date, two readings
US federal style puts the month first, so 03/04 is 4 March. UK government style puts the day first, so it's 3 April.
Source: US GPO Style Manual (2008); GOV.UK A to Z style guide; ISO 8601
The plain prompt guessed once
Real output · GPT-5.5 (OpenAI API) · Oct 2026
It flagged two of the three two-way dates. For 03/04 it picked March 4 because Dana's other row looked American. A fair guess, but still a guess.
Tell it not to guess
Tested in GPT-5.5 (OpenAI API), Oct 2026
This prompt says what to do with a date that reads two ways, and that a date reading the same either way isn't ambiguous.
Why that one line is in there
Real output · GPT-5.5 (OpenAI API) · Oct 2026
Our first version left out the "same date" sentence. It flagged all three two-way dates, but also 07/07, which can only be July 7.
Checked by hand: 8 of 8
Real output · GPT-5.5 (OpenAI API) · Oct 2026
The three CHECK rows are exactly the dates that can be read two ways. The other five match when converted by hand. That was 8 of 8 right in this run.
The CHECK rows are your to-do list
Ask whoever booked, then fix those rows by hand. This was one run, so still check the rows. Better still, have the sheet collect dates as YYYY-MM-DD from now on.
Try it: Paste 10 sample rows with the prompt and count the CHECKs.
Source: ISO 8601, ISO Help Center
Before you paste your own sheet
Remove names, account numbers and other personal details first. Then check the tool's data policy or your employer's approved tools before uploading real documents.
Sources and assumptions
- ISO Help Center: ISO 8601, international standard for date and time format (page dated 31 Jul 2025): ISO 8601 expresses dates as YYYY-MM-DD (year-month-day) and was created 'to remove the confusion caused by the many different date and time formats used worldwide, which can lead to misinterpretation and costly errors.' (checked 2026-10-27)
- U.S. Government Printing Office Style Manual (2008), Chapter 12 Numerals, rule 12.9: US federal style writes dates month first ('June 29, 1985') and gives the all-numeral example '9/11 (referring to the attack on the United States that occurred on September 11, 2001)', i.e. month/day. (checked 2026-10-27)
- GOV.UK A to Z style guide, 'Dates' entry: UK government style writes dates day first, e.g. '4 June 2017', with no ordinals ('2 June and not 2nd June'). (checked 2026-10-27)
- MIT International Students Office: Date format in the United States: The US uses month/day/year, which the page calls 'very very unique'; most countries use day/month/year (secondary, university source; supports 'the US is the outlier', not exact country counts). (checked 2026-10-27)
Assumptions:
- The booking list is fictional: rooms, names and dates are invented; no real people or companies.
- Tests ran on GPT-5.5 through the OpenAI API (label 'GPT-5.5 (OpenAI API)', Oct 2026), not the ChatGPT app. The queue idea named Claude, but headless Claude could not be run in this research session, so the post must not claim a Claude result or say the prompt works in Claude.
- Each prompt was run once; another run may phrase things differently or decide differently (the 'before' run already flagged 2 of 3 ambiguous rows, so a rerun could flag all 3 or none).
- '2027-05-09' is treated as already ISO (year-month-day); year-day-month is not a common convention.
- A date is 'ambiguous' here only when both numbers are 12 or under and differ; 07/07 is the same date either way.
- The before run's guess for 03/04 (March 4) used Dana's other US-style row as evidence; that is plausible but unverified, since a name doesn't tell you which office someone works in.
- No product features or tiers are taught, so no app documentation check is needed; the privacy line applies because readers would paste their own sheets.
The short version
- 03/04 can be two different dates.
- Tell AI to write CHECK, not guess.
- Say that 07/07 is not ambiguous.
- Check the rows by hand.


