AppearanceDate displays date and time. How do I display just the date?

mitesh114
mitesh114 used Ask the Experts™
on
I am using the appearancedate property which is a property of the Area class.  It displays the date but displays the time after the date; for eg. "24/04/2007 00:00:00."

How do I get it to remove the timestamp?  I have tried myAreaListing.AppearanceDate.ToShortDateString but it doesn't work.  

I am not able to do a replace and remove the timestamp this way because it removes the sort order.  

Any ideas?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
One way to do this is use FORMAT(your variable, "MM/dd/yyyy")

Author

Commented:
thanks for the answer.  appreciated.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial