I have a field in the database as
1/11/1995 12:00:00AM
the need is for me to just show the date, it also has to be refomatted to the opposite of what it is that is not the issue so much as how to remove the time from this field.