Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

join two strings into a date time format asp classic

Anonymous User 2879 20 Jun 2013

Hi Expert,
I have two variables X and Y. X has a date as a string(12-Jun-2013) and Y has a time (12:46 pm) I need to put these two together into a date time format before inserting in into a database. Does anyone know what function I need to use to do this?
Thanks in advance for any recommendations or solutions.

Anonymous User

Other

I am a content writter !

1 Answers

Sumit Kesarwani 20 Jun 2013

Hi Lois,

Append your two string, with a space, and use the CDate function to convert the whole thing to a date. So: CDate("12-Jun-2013 12:46 pm") will return the date-time value.

MindStick Training