topic Re: Change Timestamp format to MM/DD/YY Format in Listbox in QlikView

Change Timestamp format to MM/DD/YY Format in Listbox

Fri, 06 Dec 2013 10:20:14 GMT

Hi,

I have a listbox showing Date Field in a timestamp format(3/24/2011 12:00:00 AM).I want to display it in MM/DD/YY format.

=Date(timestamp#(ALIGNMENT_DT,'DD/MM/YYYY hh:mm:ss'),'DD/MM/YY')

But my expression is not working correctly.

Plz suggest.

Thanks.

Re: Change Timestamp format to MM/DD/YY Format in Listbox

swuehl — Fri, 06 Dec 2013 10:23:07 GMT

I think your format codes are not correct, please check the HELP.

Given your information, I would try

=Date(floor(timestamp#(ALIGNMENT_DT,'MM/DD/YYYY hh:mm:ss TT')),'MM/DD/YY')

Re: Change Timestamp format to MM/DD/YY Format in Listbox

Fri, 06 Dec 2013 10:27:58 GMT

Hi,

I have tried that too.it didn't work out.

Thanks for quick reply.

Re: Change Timestamp format to MM/DD/YY Format in Listbox

maternmi — Fri, 06 Dec 2013 10:32:42 GMT

have you tried ?

=date(timestamp,'DD/MM/YYYY')

Regards,

Michael

Re: Re: Change Timestamp format to MM/DD/YY Format in Listbox

swuehl — Fri, 06 Dec 2013 10:34:36 GMT

Seems to work for me.

Re: Change Timestamp format to MM/DD/YY Format in Listbox

Fri, 06 Dec 2013 10:35:51 GMT

Hi Have you try this

=Date(num(Date#(ALIGNMENT_DT,'DD/MM/YYYY')),'MM/DD/YYYY')

Re: Change Timestamp format to MM/DD/YY Format in Listbox

Fri, 06 Dec 2013 10:46:19 GMT

Thanks guys.Changed the Format pattern in Number to MM/YY/YY.

Re: Change Timestamp format to MM/DD/YY Format in Listbox

Fri, 06 Dec 2013 10:49:26 GMT

fixed your problem??

Re: Change Timestamp format to MM/DD/YY Format in Listbox

Fri, 06 Dec 2013 11:09:24 GMT

Yes Nirmal.Fixed it.

Re: Change Timestamp format to MM/DD/YY Format in Listbox

Fri, 06 Dec 2013 11:11:27 GMT

Then paste your answer and close this thread

Re: Change Timestamp format to MM/DD/YY Format in Listbox

Fri, 06 Dec 2013 13:26:18 GMT

Hi All,

=Date(Timestamp(EFFECTIVE_DT,'DD/MM/YYYY hh:mm:ss TT'),'MM/DD/YY') works fine.Also in Document i could able to change it but the selection still shows in timestamp format in selection listbox.Do i need to change it in script or i can do something in expression?

Thanks.