Verified65% confidenceFactExact time
Excel's 1900 date system contains a legacy bug that incorrectly recognizes February 29, 1900 as a leap day, and this bug is intentionally retained for backward compatibility.
3
Sources
65%
Confidence
Long-term
Relevance
7/15/2026
First Seen
Sources
从50%到92%：让AI智能体精通电子表格的实战方法论
Related Claims
UnverifiedTIMESTAMP has a valid range of 1970 to 2038, while DATETIME can store dates from 1000 to 9999; the 2038 upper limit stems from its use of a 32-bit signed integer to record Unix timestamps.59% similarUnverifiedThe {{ $now }} expression can be used in system prompts to reference the current time to ensure accurate date calculations.59% similar
Cite This Claim
Stable URI
https://kongchang.com/claim/517436API
curl https://kongchang.com/api/v1/knowledge/claims/517436MCP
get_claim(id=517436)