Today's AI Tip
← All posts

Is 03/04 March or April? Make AI flag it, not guess.

· View on Instagram · View on Facebook

Is 03/04 March or April? Make AI flag it, not guess.
The request most people type. 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.

The request most people type

Convert the dates in this booking list to YYYY-MM-DD.

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.

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. 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.

The plain prompt guessed once

Real output · GPT-5.5 (OpenAI API) · Oct 2026

| Harbor Room | 2027-03-04 | Dana | Interpreted as US `MM/DD` based on Dana’s `04/17/2027` entry | … | Loft | 2027-05-06 or 2027-06-05 | Tom | Ambiguous: `06/05/2027` could be UK or US | | Garden Suite | 2027-11-12 or 2027-12-11 | Lee | Ambiguous: `12/11/2027` could be UK or US |

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. 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.

Tell it not to guess

Convert the dates in this booking list to YYYY-MM-DD. Some rows use US order (month/day) and some use UK order (day/month). If a date could be read both ways, do not guess: write CHECK and both possible dates. If both readings give the same date, it is not ambiguous. Convert only the dates that can be read one way.

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. 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.

Why that one line is in there

Real output · GPT-5.5 (OpenAI API) · Oct 2026

Loft | CHECK: 2027-07-07 or 2027-07-07 | Sam

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. 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.

Checked by hand: 8 of 8

Real output · GPT-5.5 (OpenAI API) · Oct 2026

Room bookings (dates converted) - Harbor Room | CHECK: 2027-03-04 or 2027-04-03 | Dana - Garden Suite | 2027-03-25 | Priya - Harbor Room | 2027-04-17 | Dana - Loft | CHECK: 2027-06-05 or 2027-05-06 | Tom - Garden Suite | CHECK: 2027-12-11 or 2027-11-12 | Lee - Loft | 2027-07-07 | Sam - Harbor Room | 2027-05-09 | Priya - Loft | 2027-06-09 | Tom

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.

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.

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

Assumptions:

The short version

Follow @todaysaitipSave this post on Instagram

More posts