Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calculated Date

  Asked By: Keaton    Date: Jun 13    Category: Sharepoint    Views: 1137

I want to calculate a date based on a start date of calendar event. The
start and end dates are both dates and times. The Estimated ship date
is the field I want to calculate and it is just a date column and not a
date and time column. I want to calculate the estimated ship date to be
two weeks before the start date, so I put the following calculation in
=Start Date-14. When I tried to then add my estimated ship date column
to my content type I got an error because of my formula. I then changed
my formula to ="Start Date"-14 and I was able to add my column to the
content type, however when I test the functionality it did not work.

Am I having problems because my start date is both a date and time
column and my estimated ship date is just a date column? Or is there
another way I need to format the formula?



No Answers Found. Be the First, To Post Answer.

Didn't find what you were looking for? Find more on Calculated Date Or get search suggestion and latest updates.