locked
Calculated column returns invalid Date Value RRS feed

  • Question

  • i added a new column name MilestoneStatus as calculated column data type, with this formula

    ="<DIV style='background-color:"&IF(MilestoneDate<=Today,"Red","")&";'>"&MilestoneDate&"</DIV>"

    but the return value gives me a number, it should be MilestoneDate. How can i transform it to date or can i use some Format functions? pls Advise.


    cal_bonjovi
    • Changed type Mike Walsh FIN Friday, June 3, 2011 10:00 AM q
    • Moved by Mike Walsh FIN Friday, June 3, 2011 10:00 AM admin q (From:SharePoint - General Question and Answers and Discussion (pre-SharePoint 2010))
    Friday, June 3, 2011 7:02 AM

Answers

  • thanks for reading. i resolved this using Month(MlestoneDate) & "/"& Day(MilestoneDate) &"/"& Year(milestoneDate)
    cal_bonjovi
    • Marked as answer by cal_bonjovi Monday, June 6, 2011 2:59 AM
    Monday, June 6, 2011 2:59 AM

All replies

  • thanks for reading. i resolved this using Month(MlestoneDate) & "/"& Day(MilestoneDate) &"/"& Year(milestoneDate)
    cal_bonjovi
    • Marked as answer by cal_bonjovi Monday, June 6, 2011 2:59 AM
    Monday, June 6, 2011 2:59 AM
  • hi cal_bonjorvi,

    Thanks for sharing. Welcome to the forum again.

    Wayne
    TechNet Subscriber Support in forum

    Tuesday, June 7, 2011 3:56 AM