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

    Help with calculating 2 weeks Prior Date

    Kalyan Nadella

      Hi,

       

      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.