Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

More on calculated columns

  Asked By: Sanchay    Date: Sep 01    Category: Sharepoint    Views: 1189

Anyone know how to create a sentence that inserts dates from two other
columns? I tried this, but I am getting the dates in the serial number
format. I can't figure out how to get it to display the dates in an
actual date format.

4 columns:

"event date" (date and time: date only)
"details due:"(calculated column: [event date]-21)
"seed questions due:"(calculated column: [event date]-7)
"Message to coordinator" (calculated column:
="General Event Details are due on or before "&[Details Due:]&" and
Seed Questions are due on or before "&[Seed Questions Due:]&"."

My problem occurs w/ the last column. The sentence displays, but the
two dates appear as serial numbers.



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

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