Jump to content
Claris Engage 2025 - March 25-26 Austin Texas ×

This topic is 7378 days old. Please don't post here. Open a new topic instead.

Recommended Posts

Posted

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~~

This topic is 7378 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.