DatePart

  • Thread starter Thread starter Keith
  • Start date Start date
K

Keith

I'm trying to convert "mm/dd/yyyy hh:nn:ss" date format to just time using
DatePart function.

I've used DatePart("hh:nn",[TimeIn]) and it returns "Error".

I've used TEMP: DatePart("h",[TimeIn]) & ":" & DatePart("n",[TimeIn]) and it
returns the time; however, I can't compare the result to other time since it
returns the results in text format.

Any suggestions?


Keith
 
Using the TimeValue worked perfectly!

Thank you Marshall.


Keith

Marshall Barton said:
Keith said:
I'm trying to convert "mm/dd/yyyy hh:nn:ss" date format to just time using
DatePart function.

I've used DatePart("hh:nn",[TimeIn]) and it returns "Error".

I've used TEMP: DatePart("h",[TimeIn]) & ":" & DatePart("n",[TimeIn]) and it
returns the time; however, I can't compare the result to other time since it
returns the results in text format.
Click to expand...

That would be a complicated way to get the time part of a
date/time value. Try using the TimeValue function instead.
Click to expand...
 
Back
Top