[DateTime] (Top Query)

Has no parameters

Description:

HH is stored as 24 hour clock. Input however may be a 12 hour clock ending in AM or PM and it will be converted to the 24 hour clock on save.

Example:

[New] result = "19870817 6:43:55"
result [DateTime]
Html ("result: " & result) 'result is equal to 1987-08-17 06:43:55