Skip to main content

Posts

Showing posts with the label date

Batch job History Log Cleanup code in Axapta till specified date

You can clear log for batch job history in Ax by following code. This code can work in most of ax version . If you want to clear  log till some date that you can also specify in query . You can just copy and paste below code run or execute. BatchJobHistory BatchJobHistory; date startDate; TimeOfDay startTime; utcDateTime rangeStart; startDate=mkDate(21,12,2014); startTime = str2time("6:00:00 am"); rangeStart = DateTimeUtil::newDateTime(startDate,startTime); delete_from BatchJobHistory where BatchJobHistory.createdDateTime<rangeStart; //select count(RecId) from BatchJobHistory where BatchJobHistory.createdDateTime<rangeStart ; // info(strFmt("%1 till cleanup done ",BatchJobHistory.RecId)); info(strFmt("%1 till cleanup done ",rangeStart));

primitive data types in Microsoft Dynamics AX

Primitive Description String A number of characters. Integer A number without a decimal point. 32 bits wide. Real A number with a decimal point. Date Contains day, month and year. Time Contains hours, minutes and seconds. UTCDateTime A combination of date and time types into one data type that also holds time zone information. Enum A set of literals that are represented internally as integers. Container A composite data type that is a dynamic list of items containing primitive data types and/or some composite datatypes. GUID Globally Unique Identifier. A 16-byte number generated that uniquely identifies a network or interface. Int64 A number without a decimal point. 64 bits wide. Boolean Only contains the values false and true.