A Logical Date Query

[Sambucus]

Hi, I've been unable to work this out. I want to work out a price change after a certain date. eg. After May 19 2008 it has risen from $16.00 to $16.50

I tried IF(Date1=>"5,19,2008";16.5;16) and other more embarrassing attempts which I wouldn't dare to put up here!

With many thanks,

Charles

Edited May 29, 2008 by Guest
Spelling & grammar

[Lee Smith]

Try;

Case ( AnyDate ≥ Date ( 5; 19; 2008); 16.5; 16)

the dollar amounts will need to be formatted at the Layout level.

Lee

[color:red]p.s.

AnyDate represents your current Date Field.

Edited May 29, 2008 by Guest
p.s.

[comment]

The problem with your calculation is that "5,19,2008" is not a date - it's just a meaningless text string. A comparison like:

Date1 ≥ Date ( 5 ; 19 ; 2008 )

would make more sense.

However, this not a good approach overall. Calculations should calculate, not store data. Your prices should be kept in a pricelist as fields/records, and other records that need them should look up the relevant price from there.

[Sambucus]

Thank you for your speedy replies, I have now got it sorted. I didn't expect to have a price change mid season. I did have these in separate fields/records in global storage.