Hello
I created a SP with a date (docdate) as parameter. The parameter in the SP is defined as ‘@DATE as date’ also tried ‘@DATE as datetime’.
I call the SP from a Formatted Search with ‘exec GetPrice $[$-10.0.date]’
(also tried $[$10.0.date] and $[$-10.0.0] and $[$10.0.0])
When I executed the SP in mssql as ‘exec GetPrice '2012-10-25'’ I receive the wanted results, but by using the FS I receive a converting error.
I tried to use ‘CONVERT(VARCHAR(26), getdate(), 23)’ on various ways, but with no results.
Can anybody tell me how to solve this issue?
Kind regards