A
Aivars
Hello,
I have a simple table Rates, which shows what freight rates were
applicable in different time intervals/periods:
StartDate EndDate FreightRate
12.10.2005 12.10.2006 20500
12.10.2006 12.05.2007 21500
12.05.2007 12.08.2007 22000
12.08.2007 12.01.2008 23000
It is probably very simple but how can I select/determine what
FreightRate was applicable on a given specific date, lets say 25.03.2005
(should be 21500) or on 13.07.2007 (22000)?
I want to query this table and pass a specific date as a parameter to
this query to get back this freightrate number.
I could not find anything on a Google so maybe it is really simple.
Thanks a lot
Aivars
I have a simple table Rates, which shows what freight rates were
applicable in different time intervals/periods:
StartDate EndDate FreightRate
12.10.2005 12.10.2006 20500
12.10.2006 12.05.2007 21500
12.05.2007 12.08.2007 22000
12.08.2007 12.01.2008 23000
It is probably very simple but how can I select/determine what
FreightRate was applicable on a given specific date, lets say 25.03.2005
(should be 21500) or on 13.07.2007 (22000)?
I want to query this table and pass a specific date as a parameter to
this query to get back this freightrate number.
I could not find anything on a Google so maybe it is really simple.
Thanks a lot
Aivars