CDate function in Access2000 - TechRepublic
General discussion
October 16, 2002 at 11:03 PM
phingers

CDate function in Access2000

by phingers . Updated 23 years, 8 months ago

Re: Question https://www.techrepublic.com/forumqa/thread_detail.jhtml?thread_id=107753

In Access2000 I am using CDate to add [time taken] (number calculated) + [start time] using the following expression: [start_time]+CDate(“00″+”.”+Str([time taken]))

This works fine when [time taken] is less than 60 mins and rounded to whole minutes but how do I get it to work if [time taken] is more than 60 mins and not rounded?

This discussion is locked

All Comments