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

[#1]

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.

[swuehl]

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')

[#3]

Hi,

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

Thanks for quick reply.

[maternmi]

Hi

have you tried ?

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

Regards,

Michael

[swuehl]

Seems to work for me.

[#6]

Hi Have you try this

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

[#7 · Accepted solution]

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

[#8]

fixed your problem??

[#9]

Yes Nirmal.Fixed it.

[#10]

Then paste your answer and close this thread