RE: Problem with Dates !!!!!!!!!!!!

SSC Guru

Points: 1003865

January 1, 2014 at 11:57 am

Shadab Shah (12/25/2013)
I am trying to store the value return by the select in variable. I took that variable as varchar as well as date but nohing seems to work.....

That is correct. You cannot store a blank in a DATE datatype. The blank will automatically be converted to 1900-01-01. To wit, you're simply using the wrong datatype for this problem.

If you have a reporting requirement, let's see the code for that instead of the simplified example that you original posted. Then, we might be able to help.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)