Prompt that finds timestamps without a zone and secures day boundaries in reports. Paste it into an AI tool of your choice, which then finds timezone-naive timestamps.
Results depend on the tool, the model and what you enter.
Fill in
What you type stays in this browser window. We store and send nothing.
What are you checking?
daily revenue
activity log
SLA times
cohorts by day
mixed
Where do stamps come from?
database
app events
CSV import
third-party system
mixed
What stands out?
numbers jump by an hour
wrong day boundary
mismatch vs source system
prevention
new after a changeover
Your prompt
Help me find timestamps without a clear timezone in my analyses.
Report: [Report]
Sources: [Sources]
Symptom: [Symptom]
Steps: 1. Read columns, exports and the clock used to cut day boundaries. 2. Mark naive stamps, mixed zones and places where local time is read as UTC. 3. Recalculate an example across a daylight-saving or midnight boundary. 4. Propose storing everything in UTC plus a display zone. 5. List tests for day and month boundaries. 6. Write a note for the report if numbers are corrected.
Output: finding list, example calculation, store and display rule, tests and note text.
Take particular care to store in UTC and make the zone visible in the analysis.
Before you answer, check: Are all instructions met? If key information is missing or a placeholder in square brackets is still in the text, ask instead of guessing. Mark assumptions as assumptions.
You have edited the prompt. Changes in the fields above no longer overwrite it.
This is an instruction for an AI, not the result itself.
Prompt that explains a cohort table, compares cohorts at the same age and separates chance differences from real trends.
Prompt · Intermediate · about 8 min
You may use our prompts freely, including at work. Please do not republish them as your own collection. We give no warranty for AI results; check them yourself. Terms of use
