Build a date from year, month and day columns (deliveries)
A legacy export stores dates as three number columns. Combine them into one real date.
- Level
- beginner
- Time
- ~5 min
- Task
- Build the query
- Access
- Free — no account needed
Loading the practice workspace…
About this exercise
What you'll practise
Construct typed date values from numeric parts with #date.
Crumb & Co. (fictional) reads delivery records from an old ordering system that stores dates as three numbers.
Steps
- Add
Date= the date made fromYear,MonthandDay(a date value, not text). - Output
IDandDate.
Your result must
- Date is a date value
- Day 4 of month 3 is 4 March, not 3 April
- Two columns
Input
- Legacy (table)
- ID: text
- Year: number
- Month: number
- Day: number
Expected output columns
ID (text), Date (date)
| ID | Date |
|---|---|
| DL-1 | 2025-05-09 |
| DL-2 | 2026-01-03 |
| DL-3 | 2026-09-06 |