How can "2p" be a date in VBA?

Question

In Access, VBA IsDate("2p")

returns True

.
Can anyone explain the logic behind this awesome answer?

+3

Patrick honorez Apr 24 '15 at 8:45

1 answer

Trigger · Accepted Answer · 2015-04-24T08:48:24+0000

2 pm.

Dates are time. Whole numbers of days from the day they were in the past. Decompress the time of day in the proportion of 1 day (0.5 - 12 hours).