I'm doing a conversion of some legacy data. In the old application the Year, Month, Day, Hour and Minute are all stored in individual fields.
In the new database I would like to create a date field that contains all of those.
In the past I have used the CDate function to convert individual Year, Month and Day into an Access 'Date.
convertDateCCCCMMYY = CDate(wkMMStr & "/" & wkDDStr & "/" & wkCCCCStr)
What is the format to include a Hour and Minute to create an access date field containing the date, hour and minute?
Similar to the resulting contents when moving 'Now' into a date field, only in this case no seconds are available.