Date calculations and finding a price
Hi, I am working on the following and need some help.
I have a product in my database that has a price of lets say 10, but this price is only valid from 1Jan09 to 31Jul09 and the price for 1Aug09 to 31Dec09 is 12.
Product, valid day from 1Jan09 to 31Jul09, 10
Product, valid day from 1Aug09 to 31Dec09, 12
How can i make a function based on the sale date (variable) to select the correct price. So if i sell the product after 1Aug it will take the 12 as the price.