Intervalmatch problem

[mr_novice]

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

[rwunderlich · Accepted solution]

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

[mr_novice]

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

[rwunderlich]

Hard to say. If you could post another example -- without dropping the tables -- I'll take a look.

-Rob