Home > development, MOSS, MS SharePoint Sever, sharepoint, sps > Calculated Field to set a Due Date

Calculated Field to set a Due Date


=DATE(YEAR(Today),MONTH(Today),DAY(Today)+14)

As you might know calculated fields or calculated values cannot have volatile funcs like [TODAY] or [ME]……

so to use above formula, first create a column named Today (cud be single line of text or anything and no need for any default value, just create this column).

then create ur calculated field or Date and Time field and put the calculated value as above formula………

The above formula will add 14 days to the current day…….so what ever is due date, you can use this formula to calculate it….

Note: In date and time fields, you can directly set calculated values, no need to create a calculated column.

Hope this helps–
Rehman.

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: