Hi,
I have a pass through query which is fine If I hard code the date, however I want it to be able to run off this query based on a date field the form...is this possible?
The below function add's two working days to the date.
SELECT [DATABASE].[dbo].fn_CalcDate('2016-12-30', 2) AS TwoDays
I have tried to put [Forms]![Main]![CBODATE] where the date is above however I keep getting an error saying:
Conversion failed when converting date and/or time from character string (#241).
Thanks