I have a date coming in WebI MM/DD/YYYY 00:00:00 AM.
I want to display only date and delete time.
If I use left function
=Left(UserResponse("Order Date" );10)
This works fine if Date is 12/12/2010 or similar but if the we choose date 1/1/2010 or similar it shows "1/1/2010 0"
I am thinking to delete 12 characters from the right.
I need to know that how I can achoieve this?
What formula I should use?
Thanks
Bashir Awan