web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Export Regional dateti...

Finance | Project Operations, Human Resources, ...

Suggested Answer

Export Regional datetime in Excel report

(0) Share

Report

Report

Posted on by Unda

5

Hi,

I have to set the region dateTime to an excel report.

Now, it shows the system timezone (my cloud hosted machine's hour) and I want it to show my curret time.

I use:

cell.set_value("@RPL:ExtractionDateTime");
cell.AutoFitColumns();
cell = cells.get_item(rowcounter,2) ;
style = cell.Style.Font;
style.Bold = true;
cell.set_value(datetime2Str(DateTimeUtil::getSystemDateTime()));
cell.AutoFitColumns();
rowcounter ++; */
cell = cells.get_item(rowcounter,1) ;

can someone help me showing the code i shoud change? Which method I shoud use?

I'm a total beginner...

Thanks

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Mohit Rampal 12,565 Moderator on at

Like (0)

Report
Copy link

Link copied!
Hi Unda, Can you try below code

DateTimeUtil::applyTimeZoneOffset(DateTimeUtil::getSystemDateTime(), DateTimeUtil::getUserPreferredTimeZone());

dynamicsaxed.wordpress.com/.../

Was this reply helpful? Yes No

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

André Arnaud de Cal... 577 Super User 2026 Season 1

#2

Giorgio Bonacorsi 309

#3

Diego Mancassola 259

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans