web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / 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) ShareShare
ReportReport
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
I have the same question (0)
  • Suggested answer
    Beat Bucher GP Geek GPUG All Star Profile Picture
    Beat Bucher GP Gee... 28,058 Moderator on at
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

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

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 1,964

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 823 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 564 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans