Skip to Content
Former Member
Aug 29, 2007 at 03:45 PM

Dual data sources, dual date formats


Post Author: Mack

CA Forum: Formula

My question is this...

Using Crystal XI I've written a report and subreport to combine records from two Oracle dbs to provide a monthly activity cost report. The date format in the main report data is mm/dd/yyyy, and in the subreport data it's MMM-YY. I'm able to report one month at a time(using separate date parameters in each report, main & sub) but now need to produce a YTD report.

How can I handle the date format difference when providing a date range? Any help will be greatly appreciated. Thanks!