On Feb 11, 2007, at 9:04 PM, Lennox Jacob wrote:
Thanks Norman, But I have been trying this and many of my modifications of it // this date is like Tuesday, August 12, 1980 dim weekday as string dim month as string dim year as string weekday = nthfield(dateStr,",",1) month = nthfield(dateStr,",",2) year = nthfield(dateStr,",",3) dateStr = weekDay + ", " + month + " " + year to get from Tuesday, August 12, 1980 to Tuesday, 12 August 1980 or 12/08/1980, both of which are acceptable, but I was not able to do so.
dim weekday as string dim monthPart as string dim month as string dim day as string dim year as string weekday = nthfield(dateStr,",",1) monthPart = nthfield(dateStr,",",2) day = nthfield(monthPart," ", 1) month = nthfield(monthPart," ", 2) year = nthfield(dateStr,",",3) dateStr = weekDay + ", " + day + " " + month + " " + year _______________________________________________ Unsubscribe: <[EMAIL PROTECTED]> REAL Software has decided to consolidate this mailing list with the online Forums. On Monday, February 12, 2007, this mailing list will no longer be active. We encourage you to continue your REALbasic and REAL SQL Server discussions on the Forums. If you are not presently a member of the forum, please sign up today at <http://forums.realsoftware.com>.
