Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
LINKEDIN LIVE: Democratizing data to enhance customer-centricity. JULY 29TH REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
n1ef5ng1
Creator
Creator

Date formatting

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?

1 Solution

Accepted Solutions
aveeeeeee7en
Specialist III
Specialist III

Hi

Instead of using Date() use Timestamp()

Try this:

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

Regards

Av7eN

View solution in original post

1 Reply
aveeeeeee7en
Specialist III
Specialist III

Hi

Instead of using Date() use Timestamp()

Try this:

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

Regards

Av7eN

View solution in original post