As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at email@example.com and provide your corporate email address, company, and name.
So your sysdate is a string that only holds the date. Do you also have a filed like systime?
If you have you need to concatenate these fields to one field (DATETIME) and then you can start changing the format on that field. or you can decide first the manipulation on the date field and then on the time field and in the last step combine these two to one string.
prod: WF 7.6.10 platform Windows, databases: msSQL2000, msSQL2005, RMS, Oracle, Sybase,IE7 test: WF 7.6.10 on the same platform and databases,IE7
Posts: 2387 | Location: Amsterdam, the Netherlands | Registered: December 03, 2006
The book does not mention that combination. But it does give the following:
"For the record, there are eight possible date forms, four possible month transformation options and eight day transformation options (but only two results); thus the possible combinations are (8x4x8) or 256."
Anyone who doesn't have the book needs to order one.