News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics GP forum Date fields exporting ...

Microsoft Dynamics GP forum

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:

Administration and Setup

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Beat Bucher GP Gee... 28,021 Moderator 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

Quick Links

Leaderboard

#1

André Arnaud de Cal... 290,570 Super User 2024 Season 2

#2

Martin Dráb 228,683 Most Valuable Professional

#3

nmaenpaa 101,148

Leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans