AnsweredAssumed Answered

Date calculations and finding a price

Question asked by arnojansen1 on Jul 11, 2009
Latest reply on Mar 17, 2010 by comment_1

Title

Date calculations and finding a price

Post

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.

 

Cheers, 

Outcomes