I have us created a SP to insert a record into a table. I am now testing it using the right click 'execute Procedure' option. I amm presented with a screen to enter all of the parameteres that can be passed to the Sproc.
One of the parms is a date. I enter the date in the fomat 12/18/15 but it rejects it as not being in a date format. How would I entered a valid '@PaymentDate' in the value column of the screen below.
In the meantime I tried '12/18/15' and that worked.