Date & Time

[mr moe]

hi, i have a column that has the date and time combined, how do i write a qurey for example to filter all records with time greater than 5:00 PM. I know how to do it if the time value was in a seperate colum for example > Timevalue("05:00 pm") but if the date and time are combined i dont know how to it any advice please.Thanks.

 

[pbaldy]

In your query, create a new column:

TimeOnly: TimeValue(YourFieldName)

then put a criteria on it of

>#5:00:00 PM#

 

[boblarson]

Why not just add the time value as a column and then use what you've stated?

MyTime:TimeValue([FieldNameHere])

> #5:00:00 PM#

(that is the way for the criteria by the way, not with quotes)

 

[boblarson]

Oops, I'm slow again today. Actually I should do some real work anyway. So, I'll be slower than usual today.

 

[mr moe]

PPadly, thank you so much, I did what you said and it works great.

 

[pbaldy]

Happy to help. We both gave you the same answer, I just type faster. It's the higher altitude here...less air resistance.