Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

Date Format issue

Hi All,

i am getting Date format iisue!

DB:

2017-04-12 21:51:51

QV:

1/9/0000 21:51:51

Regards,

15 Replies
Anil_Babu_Samineni

May be use this?

=Timestamp('2017-04-12 21:51:51')

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anonymous
Not applicable
Author

Nope already tried this

Anil_Babu_Samineni

Where are you tried this? For me it is working

=Date(Timestamp('2017-04-12 21:51:51'),'YYYY-MM-DD hh:mm:ss')

Capture.PNG

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
prma7799
Master III
Master III

Try like below

=Timestamp# ('2017-04-12 21:51:51 ' )

or

=Timestamp#(Date#('2017-04-12 21:51:51 ' , 'YYYY-MM-DD'))

Anonymous
Not applicable
Author

In Bar chart taking date column as dimension

Anonymous
Not applicable
Author

still it is showing 1/9/000 as date in qlikview

Anil_Babu_Samineni

You can use Calculated Dimension the same if you want

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
Anil_Babu_Samineni

Can you provide sample to work on it

Please add me Anil_Babu_Samineni to interact faster when reply back. Speak low think High.

Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)
tresesco
MVP
MVP

May be :

=Date(Timestamp#('2017-04-12 21:51:51'),'YYYY-MM-DD hh:mm:ss') )