You could have made just this change in the first case.
objrs("DateColumn")="#" & Date_and_time & "#"
formatted in either mm/dd/yyyy hh:mm:ss or yyyy-mm-dd hh:mm:ss
When you use those columns as TEXT types, you will have to do some patch work to do date/time calculations on those fields.
I would suggest to use date and time as single column and datatype as date/time. That should be the right way of approach for this.
Hope that helps.
- Vijay G
Strive for Perfection