I have a report pulling from multiple data providers, including an Oracle DB and an XML source.
The Oracle database has a field for the date/time... Date= 11/3/2008 12:00AM
The XML data provider has a timestamp date/time... Timestamp= 200811030000Z
I need to link these variables (Date, Timestamp) so that the data associated with the dates can be displayed in the same charts.
I have converted the timestamp (From the XML provider) to a date using the following formula:
=ToDate(SubStr( <Timestamp> ,1 ,8) ,"yyyymmdd")
which brings the formats in-line, but I am not able to link the two variables
What can be done in this situation (aside from manipulating the data sources) to associate the variables?