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!

I have the same question (0)

All responses (11)

Answers (1)

Suggested answer

Jay Barot 1,502 on at

Like (0)

Report
Copy link

Link copied!

Hi @rp@n,

Please use this code: date2str(DateTimeUtil::date(purchLine.DeliveryDate),123,2,DateSeparator::Hyphen,2,DateSeparator::Hyphen,4)

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

thanx Jay,

i did that but got below error...

please give me more shed on this.

thanks!

Was this reply helpful? Yes No
Jay Barot 1,502 on at

Like (0)

Report
Copy link

Link copied!

can you show screenshot of full code.

Was this reply helpful? Yes No
Martin Dráb 239,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Suggested answer

Jay Barot 1,502 on at

Like (0)

Report
Copy link

Link copied!

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);

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

Hi Martin,

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

Was this reply helpful? Yes No
Verified answer

Jay Barot 1,502 on at

Like (0)

Report
Copy link

Link copied!

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);

Was this reply helpful? Yes No
@rp@n 56 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Jay Barot 1,502 on at

Like (0)

Report
Copy link

Link copied!

Yes. That's why i have sent appropriate code for that in previous reply.

Was this reply helpful? Yes No
Martin Dráb 239,022 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@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?

Was this reply helpful? Yes No