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.

[#2]

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.