Date formatting

n1ef5ng1 — Mon, 29 Sep 2014 03:13:24 GMT

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?

Re: Date formatting

aveeeeeee7en — Mon, 29 Sep 2014 03:42:30 GMT

Instead of using Date() use Timestamp()

Try this:

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

Regards

Av7eN