how to get the Date instead of Datetime in Ax 2012 r3

(0) Share

Report

Posted on by srinivas pamidi

1,737

I am writing the code to get the data from ax in to excel, but date field is coming is like as 01-05-2016 10:23:34

i want only date..

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (1)

Martin Dráb 236,859 Most Valuable Professional on at

Like (0)

Report

RE: how to get the Date instead of Datetime in Ax 2012 r3

You can easily convert datetime to date, but I can't comment on your code, because you didn't tell us anything about it. Also you can change the format in Excel.

Was this reply helpful? Yes No
Mea_ 60,284 on at

Like (1)

Report

RE: how to get the Date instead of Datetime in Ax 2012 r3

Hi srinivas pamidi,

You can use DateTimeUtil::date() to convert date time to date in x++ code.

Was this reply helpful? Yes No
srinivas pamidi 1,737 on at

Like (0)

Report

RE: how to get the Date instead of Datetime in Ax 2012 r3

Hi ievgen Miroshnikov,

In Debugger it is showing Date in excel sheet it is showing as Date time.

I am already Try this But it is Showing Error.

Argument 't' is incompatable with the required type.

xlsWorkSheet.cells().item(row,2).value(DateTimeUtil::date(budgetTmpBalanceLocal.Period));

Was this reply helpful? Yes No
Verified answer

Mea_ 60,284 on at

Like (0)

Report

RE: how to get the Date instead of Datetime in Ax 2012 r3

budgetTmpBalanceLocal.Period is already a date so you cannot convert date to date.

Could you please try to use xlsWorkSheet.cells().item(row,2).value(strfmt('%1', budgetTmpBalanceLocal.Period));

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

RE: how to get the Date instead of Datetime in Ax 2012 r3

This will work :)

xlsWorkSheet.cells().item(row,2).value(date2Str(budgetTmpBalanceLocal.Period, 123, 2, DateSeparator::Hyphen, 2, DateSeparator::Hyphen, 2,true));

Output:

01-05-2016

Was this reply helpful? Yes No