How to Prevent Excel From Misreading CSV Dates Across US and UK Formats

·1 views

When a CSV file is opened by double-clicking in Excel, the application automatically parses dates based on the computer's regional locale, which can cause UK-format dates like 28/05/2026 to be misread by US Excel and vice versa. Dates where both day and month values fall at or below 12, such as 03/04/2025, are especially risky because Excel silently assigns an interpretation without any warning. To avoid errors, users are advised to import CSVs via Excel's Data tab rather than double-clicking, and to set date columns as text to preserve the original string. For teams exchanging data regularly, adopting the ISO 8601 format (YYYY-MM-DD) is recommended as it is unambiguous, sorts correctly as plain text, and is compatible with JSON APIs and databases. Free browser-based tools, including a Date Format Fixer and an Ambiguous Date Checker, are available at FormatList to help users identify and correct misread dates before they propagate through data pipelines.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

AI Crawler Restrictions Could Quietly Fragment the Shared Web of Knowledge

Website owners are increasingly using robots.txt files to selectively block or allow specific AI crawlers, such as GPTBot or ClaudeBot, based on commercial deals or personal preferences. While each decision appears reasonable in isolation, experts warn that thousands of similar choices made simultaneously could erode the long-held assumption of a shared internet information environment. The fragmentation is not driven by malicious intent but by intellectual property protection and survival-level licensing negotiations in an ecosystem that no longer reliably sends traffic to publishers. Critically, the divergence is most visible at the retrieval layer: when AI systems access live web content, different bots may be permitted to cite entirely different sources in response to the same query. This means two AI systems could give different answers to identical questions not because of differences in reasoning, but purely due to differences in permitted access.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Why AI Prompts Are Not a System — and How to Build Skills That Last

A senior software engineer and tech lead argues that copying and reusing AI prompts is not a reliable system, because the same words can produce inconsistent outputs across different sessions and contexts. Drawing on frameworks from Glowforge CEO Dan Shapiro and AI strategist Nate B. Jones, the author distinguishes between disposable prompts and durable 'skills' — structured instructions with versioning, output contracts, and routing signals. Unlike prompts, skills specify what to produce rather than what to consider, and their improvements persist over time for both human and AI agents. The author reviewed their own order management API project to identify the best candidate for converting a prompt into a reusable skill, settling on a Gherkin scenario quality evaluation methodology that agents had repeatedly re-derived from scratch. The piece frames this shift as foundational infrastructure work, marking the start of a new phase in the author's public learning journey toward advanced AI-assisted engineering.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Packages Reusable Claude Code Skills to Eliminate Repetitive React Setup

A developer frustrated with AI coding assistants generating generic boilerplate has created a set of reusable instruction files, called SKILL.md, for Claude Code and Cursor. These skill files encode production conventions — such as auth flows, form validation, and GDPR compliance — so the AI generates project-ready code instead of bare-bones templates. The system works by automatically activating the relevant skill when a developer describes what they are building, requiring no extra prompting. A bundle of eight skills, extracted from real SaaS codebases and covering common React features, has been packaged and made available for a one-time purchase. Each skill targets React and TypeScript but includes adaptation notes for Vue, Angular, and Svelte.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Developer Builds Memory Plugin for Voice-Powered Conference Agent Using Weaviate

A developer known as Astrodevil published a technical guide on June 17 detailing how to build a memory plugin for a voice-powered conference agent. The project integrates Hermes and Openclaw agents with Weaviate's Engram memory system. The tutorial, aimed at Python developers, walks through creating persistent agent memory to enhance AI-driven conference assistants. The open-source project covers key AI and programming concepts, making it relevant for developers exploring agent memory architectures.

0 comments Read more at DEV Community