what is the below code line means? power builder

gvilbis
gvilbis used Ask the Experts™
on
dw_sheet.SetItem(iRow,"date", date( mid(sShip_Sunday,5,2) + '/' + mid(sShip_Sunday,7,2)+'/'+left(sShip_Sunday,4) ) )
      
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Top Expert 2010
Commented:
gvilbis,

Looks like it is trying to take a date literal in the form yyyymmdd, convert it to a date literal in the form mm/dd/yyyy, convert that into a date, and stick it into a worksheet or grid.

It has nothing to do with Regular Expressions :)

Patrick
SetItem is described here:
http://infocenter.sybase.com/archive/index.jsp?topic=/com.sybase.help.pb_10.5.dwref/html/dwref/CCJCBEDJdw.htm
Date function - text to date conversion.
sShip_Sunday  seems to be date without delimiters (like 20110516) and it is converted to 2011/05/16 and is whitten to "date" column, row iRow

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial