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

(0) Share

Report

Posted on by @rp@n

5,901

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 5,901 on at

Like (1)

Report

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

thanks Jay
Martin Dráb 230,235 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 5,901 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 5,901 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 230,235 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 5,901 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!

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

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Leaderboard

Featured topics

Product updates

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

Helpful resources

Quick Links

December Spotlight Star - Muhammad Affan

Top 10 leaders for November!

Tips for Writing Effective Suggested Answers

Subscribe to

Leaderboard

Featured topics

Product updates