AnsweredAssumed Answered

AF Analysis Date and Time Conversions

Question asked by vankudrea on Oct 29, 2018
Latest reply on Jan 17, 2019 by Roger Palmen



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