Python - better error messages when using dates

Review 1033 by @tryneus
Closes #1509