need help with the following statement

hmartinez

New Member

Join Date: Sep 2007

Posts: 1
#1

need help with the following statement

Sep 28 '07, 08:41 PM

=Trim("1" & Right(Str([SELECTED_DATE]),2) & "0" & Left(Str([SELECTED_DATE]),1) & "0" & Mid(Str([SELECTED_DATE]),3,1))

don't know why it is returning an error
Tags: None
debasisdas

Recognized Expert Expert

Join Date: Dec 2006

Posts: 8119
#2

Sep 29 '07, 04:03 AM

Hi hmartinez

Welcome to TSDN.

Please post all your questions in the related forum only by choosing from under the blue bar at the top of the page.
Comment

Comment