The following link is to a draft of a Redbook for DB2 Web Query. Chapter 12 has info on data manipulation.
In addition, youu can manipulate dates in the Report Assistant using a computed field. Create a new computed field and in the box where the calculation is needed put something like this:
JULIAN/I5 = JULDAT(<i>YOUR_DATE_FIELD</i>, JULIAN);
GREG_DATE/I8 = GREGDT(JULIAN, 'I8');
Last Wiki Answer Submitted: December 6, 2007 7:46 pm by WaltZ400645 pts.