Thanks Norman, Sorry to be a pain, I tried that myself too, but it gives Tuesday, August 1980 - the date 12 is not there, try it out in an editfield in RB2007R1 and you will see. Lennox
Norman Palardy <[EMAIL PROTECTED]> wrote: 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: 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 . --------------------------------- We won't tell. Get more on shows you hate to love (and love to hate): Yahoo! TV's Guilty Pleasures list. _______________________________________________ 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>.
