Prev: Forcing an ambiguous outer join
Next: Looping through data with calculations
From: Keith on 4 Jun 2010 14:31
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
From: Marshall Barton on 4 Jun 2010 14:04
Keith wrote:

>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.

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

--
Marsh
MVP [MS Access]
From: Keith on 4 Jun 2010 16:03
Using the TimeValue worked perfectly!

Thank you Marshall.


Keith

"Marshall Barton" wrote:

> Keith wrote:
>
> >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.
>
> That would be a complicated way to get the time part of a
> date/time value. Try using the TimeValue function instead.
>
> --
> Marsh
> MVP [MS Access]
> .
>
 | 
Pages: 1
Prev: Forcing an ambiguous outer join
Next: Looping through data with calculations