Hi, i am having trouble solving a date calculation. i have fields like this:

[Date due assigned by Customer] (data type Date)

[Date due for ordering materials] (data type Date/Calculation/Number???)

Then [Date due for ordering materials] is by calculation, [Date due assigned by Customer] - 60 (in other words, 60 days before customer assigned due date).

i don't know which function will return a Date type for this kind of calculation or just to satisfy my demand.

i tried using simple calculation, and it returns a large number, representing the Date in actual number of days!~

Fo example, [Date due assigned by Customer] = 2004-09-10

then, [Date due assigned by Customer] - 60 = 7xxxxx (which i need as a Date).

anyone knows how to solve this or which function to use?

thanks~~

Calculation (Date due for ordering Materials) should be type date with:

Date due assigned by Customer - 60

thanks~ it worked~

somehow i tested the same thing earlier and didn't work... but now it's working :-p