total no of records creating in a year

Business Central/NAV General Discussions
1

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

2

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

3

thank you Mr. Krishna

I got solution