Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to qualifiy on a time part of a timestamp field

Status
Not open for further replies.

charly04

MIS
Oct 28, 2009
3
CA
Hi everyone,

I have to qualify on a time part of a timestamp field, but the field is store like this
dd:mm:yy :hh:mm:ss


I have to build a filter based on a time part of the timestamp field.
for exmaple:
start_hour between 6:00 and 10:00

Thank for any help

Charly
 
Hi everyone
I tried to use a founction to convert the time part, here is my function:
ApplySimple("To_Date('05:00:00','hh:mm:ss'),#1";[Heure début])

I got an error message that says : ''please enter a valid expression''

I tried to debug it without success. could someone help me?
 
Hey Charly -

Try using following applyFunction
ApplySimple("To_Date(#1,'hh:mm:ss')",[Heure début])

Cheers

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top