3 Replies Latest reply: Sep 5, 2012 10:33 AM by Jonathan Dienst RSS

    Date format

    ahnet ceylan

      Hello ,

      I have date field its format:DD-MM-YYYY HH:MM

      I want to make format such WeekStart-WeekEnd like 19 Jan 2012 - 26 Jan 2012

        • Re: Date format
          Vigneswar Anantharam

          Below format conversion should help:

          =Date(WeekStart(Date(Now(),'DD-MM-YYYY HH:MM')),'D MMM YYYY') & ' - ' & Date(WeekEnd(Date(Now(),'DD-MM-YYYY HH:MM')),'D MMM YYYY')

           

          Replace Now() to your [Date Column]

           

          Note: The output will be a String and no longer be treated as a Date