Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
i am getting Date format iisue!
DB:
2017-04-12 21:51:51
QV:
1/9/0000 21:51:51
Regards,
May be use this?
=Timestamp('2017-04-12 21:51:51')
Nope already tried this
Where are you tried this? For me it is working
=Date(Timestamp('2017-04-12 21:51:51'),'YYYY-MM-DD hh:mm:ss')
Try like below
=Timestamp# ('2017-04-12 21:51:51 ' )
or
=Timestamp#(Date#('2017-04-12 21:51:51 ' , 'YYYY-MM-DD'))
In Bar chart taking date column as dimension
still it is showing 1/9/000 as date in qlikview
You can use Calculated Dimension the same if you want
Can you provide sample to work on it
May be :
=Date(Timestamp#('2017-04-12 21:51:51'),'YYYY-MM-DD hh:mm:ss') )