Skip to Content
0
Former Member
Oct 25, 2012 at 05:44 PM

Converting date by using a SP in a FS

47 Views

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