Hi there
As the headline say, I'm trying to make a Custom SQL string in the Database Publishing Module where I use the standard SQL-function "Dateadd".
Which you normally build like this:
DATEADD (datepart , number, date )
In my example it is:
dateadd(year, (year(date()) - year(dato)), dato)
But gives me the error:
Sql test: No value given for one or more required parameters.
What am I doing wrong?
I'm using it to build a "Birthday Database", if someone has a another way to get the output I need - I'm all ears
-kim