Well, I figured out my problem. A couple people here were mis-speaking when talking about using YYYY in my "time format", although I knew they meant date format because there are no Y's in time... (except Y isn't there enough)
But it made me look at the time format, and here's what it was: TIME format "HH:MM AP" So my datetime variable looked like this: vdatetime = 10/16/2012 "10:05 AM" DATETIME That's why it didn't insert! It didn't like the quotes! I contacted the consultant on the project (it's not my client) and he wants the time format to stay that way, so I'll have to temporarily change it and then change it back when creating my variables. All is good! Karen
