CDate Format Test
Test 1: Basic CDate Conversion
Input string: '01/02/2026'
CDate(d) result: 01/02/2026
Expected: Date only, no time (locale dependent)
Test 2: CStr on Date
CStr(CDate('15/03/2026')): 15/03/2026
Expected: Date only without time
Test 3: String Concatenation with &
Concatenation: 'Today is: ' & CDate('2026-05-20')
Result: Today is: 20/05/2026
Expected: Should show date only, no time
Test 4: Now() Function
Now(): 27/10/2026 16:33:29
Expected: Date and time (contains time)
Test 5: Date() Function
Date(): 27/10/2026
Expected: Date only, no time
Back to Home