2 Replies Latest reply: Jul 13, 2011 4:41 PM by Kalyan Nadella RSS

    Help with calculating 2 weeks Prior Date

    Kalyan Nadella



      I am trying to write a expression in a list box based on date to acheive a date prior 2 weeks.


      Here is my expression -


      =Date(Date#((LoadedDate -14), 'DD/MM/YYYY'))


      I get no results when tried above expression.


      Can someone please explain me what is the correct expression to acheive this.