how to remove ( time from date ) in excel during exporting form AX

(0) Share

Report

Posted on by @rp@n

Hi All,

Can you please let me know, i did code for excel export. it's bring data nicely.

I noticed the problem in date fieldS...

In above marked 2 columns showing value with datetime

the above 2 columns date field in AX is simply trans date datatype like...

purchLine.DeliveryDate;

purchLine.ConfirmedDlv;

i wrote below code -

excelWorksheet.cells().item(i,7).value(deliveryDate);
excelWorksheet.cells().item(i,8).value(ConfirmedDlv);

@ but in excel it showing date with time. Is it any way that i can control from AX to remove time before export in excel ?

Please give me more shed on this.

Thanks!

All responses (11)

Answers (1)

@rp@n 6 on at

Like (1)

Report

RE: how to remove ( time from date ) in excel during exporting form AX

thanks Jay
Martin Dráb 231,833 Most Valuable Professional on at

Like (0)

Report

RE: how to remove ( time from date ) in excel during exporting form AX

@rp@n, you merely repeated the same thing that I was reacting to. Could you please read my reply again and then answer the questions?
Jay Barot 1,502 on at

Like (0)

Report

RE: how to remove ( time from date ) in excel during exporting form AX

Yes. That's why i have sent appropriate code for that in previous reply.
@rp@n 6 on at

Like (0)

Report

RE: how to remove ( time from date ) in excel during exporting form AX

now i understand , why this error is appearing

i tested with modifieddatetime datatype - utcdatetime

test = date2str(DateTimeUtil::date(purchLine.modifiedDateTime),123,2,DateSeparator::Hyphen,2,DateSeparator::Hyphen,4);

working fine

but issue with deliverydate because this is date field and in parameter i need to pass utcdatetime.

so, the above code is not suitable for deliverydate field.
Verified answer

Jay Barot 1,502 on at

Like (0)

Report

RE: how to remove ( time from date ) in excel during exporting form AX

Use this line of codes

date2str(purchLine.DeliveryDate,123,2,DateSeparator::Hyphen,2,DateSeparator::Hyphen,4);

date2str(purchLine.ConfirmedDlv,123,2,DateSeparator::Hyphen,2,DateSeparator::Hyphen,4);
@rp@n 6 on at

Like (0)

Report

RE: how to remove ( time from date ) in excel during exporting form AX

Hi Martin,

i purchline, its showing date only but in excel it showing with time
Suggested answer

Jay Barot 1,502 on at

Like (0)

Report

RE: how to remove ( time from date ) in excel during exporting form AX

Hi @rp@n,

Delivery date is not datetime field. Suggestion i have given will work for datetime fields. So you can use the code as below

date2str(purchLine.DeliveryDate,123,2,DateSeparator::Hyphen,2,DateSeparator::Hyphen,4);
Martin Dráb 231,833 Most Valuable Professional on at

Like (0)

Report

RE: how to remove ( time from date ) in excel during exporting form AX

Is it true that the only problem is that time is being added? Do you really have all dates set to 2.1.1900? It looks unlikely to me.

What value do you get for the current day, for example?
Jay Barot 1,502 on at

Like (0)

Report

RE: how to remove ( time from date ) in excel during exporting form AX

can you show screenshot of full code.
@rp@n 6 on at

Like (0)

Report

RE: how to remove ( time from date ) in excel during exporting form AX

thanx Jay,

i did that but got below error...

please give me more shed on this.

thanks!

Community site session details

how to remove ( time from date ) in excel during exporting form AX

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Leaderboard

Featured topics

Product updates

Community site session details

how to remove ( time from date ) in excel during exporting form AX

Helpful resources

Quick Links

Daivat Vartak – Community Spotlight

Announcing Our 2025 Season 1 Super Users!

Kudos to the February Top 10 Community Stars!

Subscribe to this forum!

Select categories

Leaderboard

Featured topics

Product updates