3 Replies Latest reply: Oct 29, 2012 1:16 PM by Alec Harf RSS

    Date Field

    Alec Harf

      Hi,

       

      I have a date field that looks like:

       

      [End Date]

      1-May-2012

      3-June-2008

      5-April-2007

       

       

      Tried to format it so i can pull the year by itself but didn't work. Year([End Date])

      I tried to do :

      Date#([End Date]) as Date,

      Date( Date#( [End Date], 'MM/DD/YYYY' ) ) as Date,

       

      Both options didn't work. Any idea?

       

      Thxs for your help,

      Alec