Qlik Community

Qlik Education Discussions

Discussion Board for collaboration related to Qlik Education.

Not applicable

Want to convert Time stamp in database to date in Qlikview.

Hi to all

I am facing one problem i had a one column in database as "Creation Time" its data type is "time" data base is MS SQL Server 2012 R2 and i am taking this column in my qlikview application where its shows me that column as "01-01-74" when converted to date format. i am using Qlikview version 11.2 SR8. So how i will get the proper date in my app.?

Thanks in Advance.....

Dipesh Parmar.

1 Reply
Not applicable

Re: Want to convert Time stamp in database to date in Qlikview.

Date(floor(Date(Date#(myDate,'format'))))

Community Browser