calculate difference in two times 1

[DCCoolBreeze]

I need to calculate the difference between two dates and times. The DateDif works for dates but what about times?

 

[KenReay]

Hi

With DateDiff() you can get the difference in years, months, days, minutes etc, see the help file for relevant parameters

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[DCCoolBreeze]

Thanks. I figured out how to do that. But here is another problem. I read in a date/time that looks something like 01/23/2003 19:23:02 as a string from a flat file. When I CDate(sDate) where sDate is 01/23/2003 19:23:02 , I get a conversion error. If I separate the date from the time and do CDate to each individually, it works. Also if I do
sDate = "01/23/2003 19:23:02"
debug.print CDate(sDate)
I get no error. What is up with reading the date/time from an ascii file and then using CDate?

 

[KenReay]

Hi

Nothing that I can see, how is sDate Dimmed?

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[DCCoolBreeze]

I figured it out. Apparently the statement:

dtmDate = CDate(Trim(sDate))

does not work but

dtmDate = CDate(sDate)

does.

There are leading spaces and trailing spaces so I thought I would purge them out...no need. Everything works good now.