What are Time and Date literal values? How can I set initial values for variables and SQL input parameters of Time and Date types?
You should use this format #2016-05-17 12:14:00# for DateTime and #2016-05-17# for Date.

I don't think I ever used a Time literal value, so I don't know if the format is the same.