total no of records creating in a year

Hai Sir,

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

ax 2009

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…



thank you Mr. Krishna

I got solution