This is my first post. I am trying to set up a field that will calculate a date for me automatically by subtracting days from another field. I have a field for "Availability Date" and the field I need to have the date created for is "Final Files Due". I need Final Files Due to be 14 days (just a random number) before the "Availability Date. I have tried using calculations in the field controls but all I get is a "?"

Any help would be greatly appreciated!

Thanks!

Calculation would be;

Availability Date - 14

Your field, Availability Date, needs to be a real date field.

Lee

p.s.

Also, the ? is sometimes an indication that the Field is too small to display the result.

Edited December 29, 200817 yr by Guest

Also, the ? is sometimes an indication that the Field is too small to display the result.

Absolutely correct, Lee, but you forgot to mention that, to receive the ? in the field if simply too small to display the result, the field must be number. I know you know that so I just added it for clarification.

If an ? is in the field while a date then it indicates a problem. If you still get ? then it usually indicates that your RESULT is set to be a number and not a date; an easy error since the default result on ALL calculations is number (check the bottom popup). As Lee suggests, make sure it is date result.

LaRetta

Edited December 29, 200817 yr by Guest

It sounds like I was confusing it by doing this:

Availability Date - Day (14)

I was selecting the Day attribute and filling in a number in the parens.

Thank you so much for all your help!

One other thing (by the way this worked perfectly!), is there a way to have the weekend days removed from the equation?

Actually,

Availability Date - Day (14)

should work, as long as the result is set to type Date. "Day (14)" is just a convoluted way to say "14" - and this will hold for any number up to 31. After that, the returned value will roll back to 1 and start counting up again from there, since Day (32) is really the day-of-month of Feb 1, 0001.

is there a way to have the weekend days removed from the equation?

See this thread and the links from there:

http://fmforums.com/forum/showtopic.php?tid/196542/

Sorry, still a bit confusing. Is this a string of parameters I need to add to my calculation (Availability Date - 14; )? :qwery:

Didn't we solve this in your other thread? Link

Sorry, still a bit confusing. Is this a string of parameters I need to add to my calculation (Availability Date - 14; )?

No, it's a link to another thread on this forum, where you will find the answer to your question.

Didn't we solve this in your other thread?

Did you discount the weekends in the other thread?

We did solve the warning issue (thanks!) but I just don't want the availability or file due date to be on a weekend since that is not considered a valid "work day".