topic Re: Help with Data format in QlikView

Help with Data format

Wed, 25 Nov 2020 16:16:04 GMT

Hi,

I have my date columns are showing up as below.. I tried to change the number format settings and used date(date#()) function..I need it to be displayed as MM/DD/YYYY HH:MM:SS.

Please advice.. Thanks in advance

Re: Help with Data format

sunny_talwar — Thu, 18 Aug 2016 01:46:48 GMT

May be like this:

TimeStamp(TimeStamp#(Left(ReceivedDateTime, 14), 'YYYYMMDDhhmmss'), 'MM/DD/YYYY hh:mm:ss') as ReceivedDateTime

Re: Help with Data format

engishfaque — Thu, 18 Aug 2016 06:37:09 GMT

Dear Mohan,

Here it is,

inline_table:

LOAD Date(Timestamp#(Date, 'YYYYMMDDhhmmss'), 'MM/DD/YYYY hh:mm:ss') as Date Inline [

Date

20160418101110016

];

Kind regards,

Ishfaque Ahmed

Re: Help with Data format

Thu, 18 Aug 2016 13:22:50 GMT

Thanks sunny and Ishfaque Ahmed.. Both worked for date in format "20160418101110016" but didn't work for date in exponent form...