Calculated date field

[vincent]

I would like to define a fiel that get galculated form an
other field.
Both field are dates. The second is calculated base on
the first. It should be 3 weekdays prior to the first.

so if the first is today Monday, Novembre 17 2003, the
second should calculat has Novembre 12 2003.

in the field definition I have try various combination
such has =DateAdd(-3,"w","First Date")in the Default value

Suggestion!

 

[Jack D.]

I would like to define a fiel that get galculated form an
other field.
Both field are dates. The second is calculated base on
the first. It should be 3 weekdays prior to the first.

so if the first is today Monday, Novembre 17 2003, the
second should calculat has Novembre 12 2003.

in the field definition I have try various combination
such has =DateAdd(-3,"w","First Date")in the Default value

Suggestion!

Use ProjDateSub. Here is the syntax:

ProjDateSub
Returns the date that precedes another date by a specified duration.
Syntax
ProjDateSub( date, duration, calendar )
date Required; Variant. The original date from which duration is
subtracted.
duration Required; Variant. The duration to subtract from date.
calendar Optional; String. The calendar to use when calculating the date
difference. If calendar is not specified, the default for the current
resource is the resource calendar, or for the current task, the task
calendar or the standard calendar if there is no task calendar.

The = sign is not necessary in the formula and will cause an error.
--
Please try to keep replies in this group. I do check e-mail, but only
infrequently. For Macros and other things check http://masamiki.com/project

-Jack Dahlgren, Project MVP
email: J -at- eM Vee Pee S dot COM


+++++++++++++++++++