Hi,
I have used a web service connection to extract data from the database. For a column with data type “Date” in teradata I have used the object type as “OBJECT”. Now it return something like ‘2009-01-01T00:00:00’. How can I convert it to ‘DD-MM’ format. 
ADM171 
(BOB member since 2005-05-23)
Use some MS Excel formulas to strip out the portion, such as Left/Right functions, etc. As an alternative modify your web service to return the column as a STRING in the desired format “dd-mm” (which I would prefer).
Andreas 
(BOB member since 2002-06-20)
Following on…
If I get my dates as dates, oracle brings them through as 01/01/2009. It doesn’t matter how I format the column in xcelsius or how I format the graph, the axis displays as 01/01/2009 (even though I’ve set the axis format to mmm-yy).
If I convert the date to a string formatted as mon-yy in oracle and then grab the data, the axis looks wonderful, except that then the xcelsius forecast function falls over. Even if I set the forecasted months to be strings also, it just gives me divide by zero errors, which is odd since I’m not dividing anything at all.
All I am trying to do is grab 3 years’s data in oracle (using aspx/xml), plot a monthly total with a monthly trend line on a graph, and then show a 3 month forecast from the trend line. It works perfectly when I cut-and-paste the code directly, but not when grab the data via a connection.
How hard can this be?
debbie
edited to add: answer - use two columns, one for axis display and one for calculations. Clunky, but works. Forecasting doesn’t though - see separate post…
Debbie 
(BOB member since 2005-03-01)