0 - 2 of 2 tags for invalid

Hi all,
I have some problem about the query which finds the data between 2013-12-31 and today
I took invalid timestamp error.
The query I used looks like this:
select * from table1 where the_date between '2013-12-31' and current_time
Please help me!

Is there any way to find whether the procedure is valid, without recompiling it?
I came across a Proc, which i tried to Recompile, it just fails with missing column on one of the underlying table.
I dont want to recompile all procs, just to find whether they are valid are not.