Custom Fields Formula

[Harry]

I need help in the formula for establishing a custom field.
How can I establish a custom field to define a date that is 2 weeks (10
bus days) ahead of the current date?
For Example, If the current date is 2/25, then the custom field date should
be 3/11.

How can I formuate this custom field?

Thanks,

Harry

 

[JulieS]

Hi Narry,

Insert a custom field (Date1 for example). Right click on the column
heading and choose Customize Field from the shortcut menu. Click on the
Formula option button and insert the following formula:

ProjDateAdd(NOW(),4800)

The formula assumes you are using an 8 hour day (8 hrs * 60 minutes per hour
* 10 days.)

Hope this helps. Let us know how you get along.

Julie

 

[Harry]

Thanks Julie- It worked, I tried using ProjDateAdd before , but didn't get the
desired results.

Another question please, How can I create a date range custom field. e.g.,
5 bus. to 10 bus days from today's date. Do I need to create 2 custom fields
and subtract one from the other in the formula? If so what is the formula?

Thanks

Harry

 

[Harry]

Thanks Julie- It worked, I tried using ProjDateAdd, but didn't get the
desired results.

Another question please, How can I create a date range custom field. e.g.,
5 bus. to 10 bus days from today's date. Do I need to create 2 custom fields
and subtract one from the other?

Harry

 

[JulieS]

Hi Harry,

Glad to know the first formula worked as you needed and thanks for the
feedback.

I am not sure I fully understand your second question. I don't believe it
is possible for a Date field to show a range of dates. You certainly could
create another custom date field using the ProjDateAdd to create your second
date value (today plus 5 days) and could concatonate those two values in a
Text field.

Perhaps if you tell us what you are trying to accomplish with the date
range, we can give you a better answer or provide an alternative.

Julie

 

[Harry]

Julie,

I created another custom field and used it.

Thanks

Harry

 

[JulieS]

H Harry,
Glad you got it sorted out. Let us know if we can assist again.
Julie