1 Reply Latest reply: Sep 28, 2014 11:42 PM by AVIRAL NAG RSS

    Date formatting

    ben lim

      Hi , I have this particular field call

       

      Event Date

      This is my loading script

       

           Date(CN_Event_Date,'YYYY/MM/DD hh:mm:ss') as CN_Event_Date, 

       

      the output in QV table is 2013/12/27 11:11:00

       

      however when i export to excel, it became this format 

      2013/12/27 :

       

      user have to go to format cell in excel to change to yyyy/mm/dd hh:mm:ss in order to get  2013/12/27 11:11:00

       

      Hence, is there any solution to that?