'createdtime' for records in axapta

Finance and Operations/AX Developer Forum
1

Hi,

I am reporting on the axapta (3.0) data directly from SQL server.

I enabled “CreatedDate” and “CreatedTime” for the table in axapta to use that as my reporting parameter in ssrs.

The createdTime co,lumn has only integer value (time converted into seconds.) Does anybody know which class does this? I want to see how it handles the AM/PM

thanks,

-abid

2

That’s definitely somewhere in AX kernel. But what you need is just to convert the number of seconds to DATETIME and then apply a date format.

The conversion can be done somehow like this: SELECT DATEADD(second, CreatedTime, CreatedDate)).

3

Thanks,

i went other way round to convert the parameter value to seconds. I thought conversion on log records would be more resource consuming than converting the parameter value.

I appreciate your response.

-abid