[Trish Robertson]

When exporting a Smartlist from Excel – the date columns are coming across with the formula as text.  See Column A, H & I

I’ve checked Excel to make sure the display formulas is unchecked.  I’ve performed the export as SA and the user from 2 different machines and get the same result.  Any ideas on how to get it to export as a date?

——————————
Trish Robertson
Helpdesk Supervisor
CFRLTD
Greenville SC
——————————

[Terry Horn]

Hi Trish,

 

You have probably already checked this, but is the field defined as a date in SmartList Builder.

 

The other item I would check is whether or not if you have

SmartListEnhancedExcelExport=True

 

I found this string also if it helps any https://community.dynamics.com/gp/f/32/t/119753

 

Terry

 

——Original Message——

When exporting a Smartlist from Excel – the date columns are coming across with the formula as text.  See Column A, H & I

I’ve checked Excel to make sure the display formulas is unchecked.  I’ve performed the export as SA and the user from 2 different machines and get the same result.  Any ideas on how to get it to export as a date?

——————————
Trish Robertson
Helpdesk Supervisor
CFRLTD
Greenville SC
——————————

[Trish Robertson]

SmartListEnhancedExcelExport=True  – this worked!  Thanks

——————————
Trish Robertson
Helpdesk Supervisor
CFRLTD
Greenville SC
——————————
——————————————-