topic Re: Timestamp format in QlikView

Timestamp format

nareshthavidishetty — Wed, 25 Nov 2020 16:16:04 GMT

Hi everyone,

As I am stuck while converting a field into timestamp format. My sample Data looks like below and I have attached the sample excel file.

1/17/2017 8:28:11AM

Expected output = 'DD-MM-YYYY hh:mm:ss'.

Thanks in advance.

Anonymous — Fri, 27 Jan 2017 08:41:53 GMT

=date(date#('1/17/2017 8:28:11AM','M/DD/YYYY h:mm:sstt') , 'DD-MM-YYYY hh:mm:ss' )

tresB — Fri, 27 Jan 2017 08:45:45 GMT

Try like:

=TimeStamp(Timestamp#('1/17/2017 8:28:11AM', 'MM/DD/YYYY h:mm:ssTT'),'DD-MM-YYYY hh:mm:ss')

nareshthavidishetty — Fri, 27 Jan 2017 09:40:28 GMT

Hi,

Ya its working fine if we use that in front end.

But the problem is if I load that Excel file and then use that in script its not working.

Could u please load the Excel file which I have attached and convert that field to Timestamp.

Thanks

tresB — Fri, 27 Jan 2017 09:43:15 GMT

I don't find any excel attached.

nareshthavidishetty — Fri, 27 Jan 2017 09:50:31 GMT

Sorry for that.

Please find the attachment.

tresB — Fri, 27 Jan 2017 10:00:03 GMT

Try:

TimeStamp(Timestamp#([Email Sent Date], 'MM/DD/YYYY h:mm:ssTT'),'DD-MM-YYYY hh:mm:ss') as NewDate

Anonymous — Fri, 27 Jan 2017 11:06:28 GMT

In addition,

you will get the same result with using Date function.

Date(Date#([Email Sent Date], 'MM/DD/YYYY h:mm:ssTT'),'DD-MM-YYYY hh:mm:ss') as NewDate