Hi gang,

I am going nuts!

But besides that, I have a problem with one of my calculations.

In my job table I have a field called Job::Date_Received.

In my job line item table I have a price field called JLI::Price_Actual.

In my price table, I have two fields called Price::Rate_A and Price::Rate_B.

the Price_Actual field is an auto enter calc as follows:

if(Job::Date_Received < "09/12/05";Price::Rate_A;Price::Rate_B.

It doesn't work.

I used my data viewer and put in Job::Date_ Received. It showed 07/14/04.

I put in a calc that said:

if(Job::Date_Received < "09/12/05";1;0).

It comes up "0". What the heck am I doing wrong?

I reversed it to show if > instead of less than thinking maybe something was wrong and it just showed the default but it changes to "1", so its not just going to default. I removed the quotation marks and still the same thing. This does not make any sense to me.

This should work:

If( Job::Date_Received < GetAsDate( "09/12/05") ; 1 ; 0 )

thank you!

GetAsDate should work, but using Date( 9; 12; 2005 ) is even more foolproof, especially if you have any international users.