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...



  • In reply to Krishna Rao Gummadi:

    thank you Mr. Krishna


    I got solution