5 Replies Latest reply on Oct 30, 2018 7:50 AM by gregor

    AF Analysis Date and Time Conversions

    vankudrea

      Hi,

       

      1) I have an AF Analysis which returns the last time an AF Attribute had received a value (PrevEvent) and it does so in the time format such as 10/18/2018 5:00:00 PM. However, I need it to be in the format 18-Oct-18 17:00:00. What is the quickest way to do so ? I know a concat function will work in which I separate out the individual components in the required format and just concatenate them but I would prefer a better way.

      2) how do i round-off an year to 2 decimal digits such as 18 instead of 2018 or 14 instead of 2014.

       

      Thanks in advance,

      Amit Vankudre