Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Calculated Date

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

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?

Share: 

 

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.




Tagged: