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

[#1]

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.

[#2]

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