A quick reminder to my self:
When creating a parameter and want to use it in filter / calculation, there must be a default. For date default this is the default format:
DATE '2014-04-12'For example:
Val_Date = @parameter("P_DATE")(DATE '2014-04-12')
