Date/time data
Name:
Date:
Class:
A
Quick Questions
Shade in the A or B circle for each question.
1. Which data type is best for storing the date a student enrolled, such as 25/03/2025?
2. Which value is a valid date in DD/MM/YYYY format?
3. In DD/MM/YYYY format, what does 03/11/2025 represent?
4. What is a time stamp?
5. Why is it useful to store dates as date/time data rather than text?
B
Match the Pairs
Draw a line connecting each item on the left to its match on the right.
| Left column | Right column | |
|---|---|---|
| 125/03/2025 | AStoring a date as text means it cannot be sorted by date or used to calculate a duration; it should use the date/time type | |
| 2=B2-A2 | BORDER BY OrderDate ASC | |
| 3A time stamp records the exact date and time an event happened | C25/03/2025 14:30 | |
| 4Date/time values can be sorted in order from oldest to newest | DThis is not a valid date because February never has 31 days, so a date/time field would reject it | |
| 5Date field value: 31/02/2025 | ECalculates the duration (number of days) between two dates stored as date/time values | |
| 6BirthDate stored as text: "5th May 2009" | FA date in DD/MM/YYYY format, the day then month then year used in Australia |
C
Definitions
Date/Time
D
Fill in the Blanks
Complete each line of code by filling in the missing parts.
1.
Field name: DueDate
Data type: _________
2.
=____(B2,A2)
3.
Format: DD/__/YYYY
4.
=___()
5.
Days taken = EndDate _ StartDate
E
Spot the Error
Shade in the letter of the line that contains an error.
Question 1
A
Data type: Boolean
B
Field: DueDate
C
Format: DD/MM/YYYY
D
Example: 25/03/2025
Question 2
A
Field: StartTime
B
Data type: Date/Time
C
Format: DD/MM/YYYY
D
Example: 14:30
Question 3
A
A2: 01/03/2025
B
B2: 31/02/2025
C
C2: =B2-A2
D
C2 shows 24 days
Question 4
A
start ← 01/03/2025
B
end ← 15/03/2025
C
days ← end + start
D
OUTPUT days
Question 5
A
Field: LoginStamp
B
Stores: the date only
C
Example: 25/03/2025 14:30
D
Sort: oldest to newest
Answer Key
Date/time data
Section A: Quick Questions
Q1
A — Date/time
Q2
B — 07/09/2024
Q3
A — 3 November 2025
Q4
B — A record of the exact date and time something happened
Q5
A — They can be sorted in true calendar order
Section B: Match the Pairs
Q1
25/03/2025 → A date in DD/MM/YYYY format, the day then month then year used in Australia
Q2
=B2-A2 → Calculates the duration (number of days) between two dates stored as date/time values
Q3
A time stamp records the exact date and time an event happened → 25/03/2025 14:30
Q4
Date/time values can be sorted in order from oldest to newest → ORDER BY OrderDate ASC
Q5
Date field value: 31/02/2025 → This is not a valid date because February never has 31 days, so a date/time field would reject it
Q6
BirthDate stored as text: "5th May 2009" → Storing a date as text means it cannot be sorted by date or used to calculate a duration; it should use the date/time type
Section C: Definitions
Q1
Date/Time — A data type that stores a calendar date and/or time of day, such as 25/03/2025 or 14:30, so values can be sorted in order and used to calculate the duration between two dates.Section D: Fill in the Blanks
Q1
Field name: DueDate
Data type: Date/TimeQ2
=DAYS(B2,A2)Q3
Format: DD/MM/YYYYQ4
=NOW()Q5
Days taken = EndDate - StartDateSection E: Spot the Error
Q1
A — A due date holds a calendar date, so it needs the Date/Time data type. Boolean only stores true or false. The line should be 'Data type: Date/Time'.
Q2
C — A time of day uses an hours and minutes format like HH:MM. DD/MM/YYYY is a calendar date format and does not match the example 14:30.
Q3
B — 31/02/2025 is not a real date because February never has 31 days. A spreadsheet would treat it as text and the subtraction would fail. It should be a valid date such as 25/03/2025.
Q4
C — The duration between two dates is found by subtracting the earlier date from the later one. Adding dates is meaningless. It should be days ← end - start.
Q5
B — A time stamp records both the date and the time of day, as the example 25/03/2025 14:30 shows. It should say the field stores the date and time together.