6 Replies Latest reply: May 21, 2018 9:57 AM by arjun rao RSS

    Convert Date and calculate duration

    Christiane Lapeyre

      Hi the community !

       

      I have to resolve 2 issues and i do not manage for now to do it :

       

      Format Date :

      I do not manage to format this Date/Timestamp : 02/10/2014 08:55      to    02/10/2014

      I tried many functions as

      Date, Date(num(...)), Timestamp or

      MakeDate (02/10/2014 08:55,'DD/MM/AAAA')

      But it doesn't work.

       

      Duration between 2 dates :

      I have to calculate a duration, and convert it in number of year, or months.

      What is/are the function(s) that allow(s) that ?

       

      Thank you for your help !