topic date and Timstamp in QlikView

date and Timstamp

lawrance — Tue, 25 Apr 2017 15:23:49 GMT

Hi,

Could someone please explain the below date format difference in QlikView.

date(date#(Field_Name),'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')

Timetamp(Timestamp#(Field_Name),'MM/DD/YYYY hh:mm:ss'),'MM/DD/YYYY hh:mm:ss')

Thanks,

Lawrance A

Re: date and Timstamp

Anonymous — Tue, 25 Apr 2017 15:35:29 GMT

Both are much of same when you are specifying the format like "MM/DD/YYYY hh:mm:ss" in this case. If you leave the format to default then you can find the difference. Time part is extra in the Timestamp()