Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All!
I have a problem with intervalmatch. I just cant get it to work. I think I have a problem with the Time-field but I dont know how to change it.
Im attaching my testfile.
I hope someone out there can give me som suggestions how to change my code.
Thank you!
Br
cris
You'll need to extract the time portion from the timestamp by using frac().
time(frac(DelDate),'hh:mm') as Time
The time() functiom only formats the display value, it does not extract the time only.
-Rob
You'll need to extract the time portion from the timestamp by using frac().
time(frac(DelDate),'hh:mm') as Time
The time() functiom only formats the display value, it does not extract the time only.
-Rob
Thank you Rob!
You solved my problem. I didnt think about that. Now there's another problem. I dont get a match with all intervals even though a match should be done. I have a match to only only one row in the 'interval table'. Could it still be a time-format problem?
Br
cristian
Hard to say. If you could post another example -- without dropping the tables -- I'll take a look.
-Rob