News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... Date fields exporting ...

Finance | Project Operations, Human Resources, ...

Suggested answer

Date fields exporting as formula =date(2021,10,10) when exporting to Excel from Dynamics GP2015

(0) Share

Report

Report

Posted on by Gilberto J Ojeda R

10

Hi,

When I export a smartlist that has date fields to excel, it does it this way: = date (2021,10,10), how can I correct it?

I already checked the regional configuration of the server, the sql server collation and the problem persists, please help

Thanks

Gio

Categories:

Microsoft Dynamics GP

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,021 Super User 2024 Season 1 on at

Like (0)

Report

RE: Date fields exporting as formula =date(2021,10,10) when exporting to Excel from Dynamics GP2015

Dear Gilberto,

Try to add this line into the DEX.ini file :

SmartlistEnhancedExcelExport=TRUE

See details here:

www.erpsoftwareblog.com/.../

Be aware of the resultant issues that could be caused by this change:

community.dynamics.com/.../smartlist-export-oddities

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2

Martin Dráb 230,370 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans