I want to find the purchase order table having records for creating a particular year ..want to write coding in jobs and want to get it in info message ..
can any one give sample coding for identify the records totally create for a year
select count(Recid) from purchtable
where purchtable.createdDateTime >= Datetimeutil::newDateTime(1\1\2014,00)
&& purchtable.createdDateTime <= datetimeutil::newDateTime(31\12\2014,86399);
please select correct forum while posting...
In reply to Krishna Rao Gummadi:
thank you Mr. Krishna
I got solution