I have the attached crystal report where there are two tables. One is a SQL View I created which provides the current fiscal date info - there are two fields I am using to link data to the InvoiceHeader tableprevious_qtr_start_date
previous_qtr_end_date
I am joining both fields to the "InvoiceHeader.posted-to-ar-date" and selecting Link Type <= for end date and >= for start date.
sample.rptIn doing so it does not return any records. I have verified same format and still no luck. What is the best way to do this as the view was created to determine the current fiscal quarter and then provide the start and end dates for the previous quarter. The view works great on its own but cannot get to join to data table and return results.