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);

          info(int2str(purchtable.RecId));

    please select correct forum while posting...

    regards,

    krishna

  • In reply to Krishna Rao Gummadi:

    thank you Mr. Krishna

     

    I got solution

Related