asked on What Format to Enter Date To Execute SP?
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.
![Sproc Date Entry]()
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.
Microsoft SQL Server
Last Comment
mlcktmguy
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Not the correct answer but I appreciate the response.
Oh I see...it was just the quotes you were missing.
ASKER
Good point, the quotes were the key. After your comment about the quotes, I went back and tested your answer with quotes around it, it worked also.
Thanks for the followup and pointing out the quotes were the key.
Thanks for the followup and pointing out the quotes were the key.
In the meantime I tried '12/18/15' and that worked.