4 Replies Latest reply: Mar 21, 2016 4:40 AM by Hasvine Dhurmea RSS

    Calculation On month

    Hasvine Dhurmea

      Hello All,

       

      I had to convert "DATE_FACTURATION" which is in the format of DD/MM/YYYY  into Monthname and Year (example (14/03/2016 into Mar-2016) and I managed to do it using the below:

       

      month(Date(alt(Date#(DATE_FACTURATION, 'DD/MM/YYYY')), 'DD/MM/YYYY')) & '-' & year(Date(alt(Date#(DATE_FACTURATION, 'DD/MM/YYYY')), 'DD/MM/YYYY')) as Mois_enquete_calcul,

       

       

      However now I need to use the date "DATE_FACTURATION" to calculate the date minus 6 months and to show in the format of Monthname and Year.

       

      Example:

       

      DATE_FACTURATION     Mois_enquete_calcul

      14/03/2016                      Aug-2015

       

      Any idea?

       

      Kind Regards,

      Hasvine