Date Format issue

[Anonymous]

Hi All,

i am getting Date format iisue!

DB:

2017-04-12 21:51:51

QV:

1/9/0000 21:51:51

Regards,

[Anil_Babu_Samineni]

May be use this?

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

[Anonymous]

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')

[prma7799]

Try like below

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

or

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

[Anonymous]

In Bar chart taking date column as dimension

[Anonymous]

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

[Anil_Babu_Samineni]

You can use Calculated Dimension the same if you want

[Anil_Babu_Samineni]

Can you provide sample to work on it

[tresesco]

May be :

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