5 Replies Latest reply: Jan 20, 2018 9:32 PM by Yeo Poh sai RSS

    SubField([Created Time],'-' ,3) as Year_CD, How to remove the time ?

    Yeo Poh sai

      Hi All


      I have below script :-

      [Opportunities Created Time] as      [Created Time],


      it will display the date and time :-

      01-02-2018 08:27:20

      01-04-2016 03:03:46

      01-04-2016 03:09:00

      01-05-2015 01:18:00


      May i know how to make it display as below :-

      Jan-02-2018

      Jan-04-2016

      Jan-04-2016

      Jan-05-2015


      I have try :-

      SubField([Created Time],'-' ,3) as Year_CD,

      2014 00:36:19

      2014 00:43:42

      2014 00:50:23

      2014 00:50:54


      My question is how to remove those time and make it look like below ?

      2014

      2014

      2014

      2014


      Also may i know how to add the month inform ? So that i it can display as below :-


      Jan 2014

      Jan 2014

      Jan 2014

      Jan 2014



      Thank you