How to qualifiy on a time part of a timestamp field

[charly04]

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

 

[charly04]

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?

 

[itsshahed]

Hey Charly -

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

Cheers