I can use the FORMAT function to get the date formatted properly, my problem is I can't figure out how to get the report to pull the values the user enters into the parameter boxes
Here's some further details....
The report pulls info from two unrelated tables, so the record source for the report is a join query. The SQL is as follows:
SELECT PO.POID, PO.PrimaryLOB, PO.ProjectName, PO.[Term of Contract], PO.[Contract Life Spend], PO.[CY Spend], PO.[CapBudgeted Amount], PO.[OpBudgeted Amount], PO.BudgetCenterNumber, PO.GLAccountNumber, PO.[CapInitial Vendor Pricing], PO.[OpInitial Vendor Pricing], PO.[CY CapBud PL], PO.[CY OpBud PL], PO.[CY CapNBud PL], PO.[CY OpNBud PL], PO.[CY Total PL], PO.[CY Cash Save], PO.[FY Total P/L], PO.[FY Cash Save], PO.Date, PO.[FYCapFinal Vendor Pricing], PO.[FYOpFinal Vendor Pricing]
FROM PO
WHERE (((PO.Date)>=[Enter Report Start Date] And (PO.Date)<=[Enter Report End Date]))
UNION SELECT [Financial Data].ID, Data.[Primary LOB], Data.[Project Name], [Financial Data].[Term of Contract], [Financial Data].[Contract Life Spend], [Financial Data].[CY Spend], [Financial Data].[CapBudgeted Amount], [Financial Data].[OpBudgeted Amount], Data.[Budget Center Number], Data.[GL Account Number], [Financial Data].[CapInitial Vendor Pricing], [Financial Data].[OpInitial Vendor Pricing], [Financial Data].[CY CapBud PL], [Financial Data].[CY OpBud PL], [Financial Data].[CY CapNBud PL], [Financial Data].[CY OpNBud PL], [Financial Data].[CY Total PL], [Financial Data].[CY Cash Save], [Financial Data].[FY Total P/L], [Financial Data].[FY Cash Save], [Financial Data].Date, [Financial Data].[FYCapFinal Vendor Pricing], [Financial Data].[FYOpFinal Vendor Pricing]
FROM Data RIGHT JOIN [Financial Data] ON Data.ID = [Financial Data].[Contract ID]
WHERE ((([Financial Data].Date)>=[Enter Report Start Date] And ([Financial Data].Date)<=[Enter Report End Date]));
As I stated before the user gets to the report by clicking a button and entering a start date and end date. Both the start date and end date are pulled from (1) Date field in the underlying tables. The SQL is as follows:
WHERE (((PO.Date)>=[Enter Report Start Date] And (PO.Date)<=[Enter Report End Date]))
WHERE ((([Financial Data].Date)>=[Enter Report Start Date] And ([Financial Data].Date)<=[Enter Report End Date]));
I have a text box on my report where I want the dates to show - but I can't figure out how to get the report to know what the user typed in for the start date and end date