Nov 11, 2009 #1 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 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
Nov 11, 2009 Thread starter #2 charly04 MIS Oct 28, 2009 3 CA 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? Upvote 0 Downvote
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?
Mar 23, 2010 #3 itsshahed Technical User Mar 9, 2010 1 IN Hey Charly - Try using following applyFunction ApplySimple("To_Date(#1,'hh:mm:ss')",[Heure début]) Cheers Upvote 0 Downvote
Hey Charly - Try using following applyFunction ApplySimple("To_Date(#1,'hh:mm:ss')",[Heure début]) Cheers