Session relevance query

(imported topic written by Darknight)

Hi All,

Can someone please let me know whtehr i can convert the below output of property ‘last report time’ in ‘date-month-year time in hours:mins:sec’ format .

for example :output of property ‘last report time’ is Fri, 20 Jun 2014 15:21:45 +0100

desired output : 20-june-2014 15:21:45

Please adivise.

Thanks in advance

(imported comment written by Darknight)

can someone please provide some hint…thanks

(imported comment written by Darknight)

Can someone please reply …

(imported comment written by baonhan)

Use the following relevance in a new property:

(day_of_month of item 0 of it as string & “-” & (it as string as lowercase) of month of item 0 of it & “-” & year of item 0 of it as string & " " & two digit hour of item 1 of it & “:” & two digit minute of item 1 of it & “:” & two digit second of item 1 of it) of (date (local time zone) of it, time (local time zone) of it) of (apparent registration server time)

(imported comment written by Darknight)

thank you very much baonhan :slight_smile: