Skip to Content
0
Apr 19, 2010 at 09:32 PM

Trim 12 characters from right side

3011 Views

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