locked
Using the [Modified] column in an IF statement not working RRS feed

  • Question

  • I'm importing multiple Excel documents into a new SharePoint library and I would like to preserve the last date the document was modified in IE. I have created a column called [IE Last Edit] however I cannot get my formula to work in the [MOD] calculated field which I need to track when the documents are modified going forward.

    Please assume that all the documents were uploaded on 04/04/2013

    Formula is =IF([Modified]>"04/04/2013",[Modified],[IE Last Edit])

    The results only produce the [IE Last Edit] value. I have tried everything and hope someone can tell me where i'm going wrong.

    Thank You

    Friday, April 12, 2013 10:02 AM