Discussion Board for collaboration related to QlikView App Development.
Hi , I have this particular field call
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
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?
Instead of using Date() use Timestamp()
=Timestamp(CN_Event_Date,'YYYY/MM/DD hh:mm:ss') as CN_Event_Date,
View solution in original post