Excel → T-SQL › DATE
Excel DATE to DATEFROMPARTS
Build a date from year, month, day columns. Do not concatenate strings and hope.
DATEFROMPARTS(y, m, d)
-- dirty
TRY_CONVERT(date, DATEFROMPARTS(y, m, d))DATEFROMPARTS(2026, 2, 31) errors. TRY_CONVERT after a valid-day check, or clean first.
Canonical translation
DATEFROMPARTS(y, m, d)
-- dirty
TRY_CONVERT(date, DATEFROMPARTS(y, m, d))Then write it on a ticket
Monday is free. A colleague asks, you type, we mark it.
Clock in free