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 !