I searched on the forum and the only solution that I saw was to create a calculated column as varchar. However, pretty sure that by doing that, we’ll lose the ability to correctly filter the date in the dashboards, no ? And it seems like a lot of work to rework on all our dashboards just because the default export option doesn’t format the date as it’s shown in the grid
Is there an alternative to this or is there a simple way in Excel to format the column ? I tried to change the format to custom but nothing changes
=DATEVALUE(LEFT(A2, FIND(“T”, A2) - 1))
Note careful with the copy/paste of the double quotes. they copy as curly quotes and they need to be straight.
Where A2 is your date field.
With the amounts of Dashboards that we have, it would be a lot of work to add calculated columns and then change the customization layer to reference that new column. Changing row rules sometimes too
I understand that if we knew that before, it would have been done when building the BAQs but most of these BAQs were started on Epicor Classic and the export worked correctly for these columns in the Classic Dashboards
Let’s hope that Epicor allow us to choose how we want this export to behave with dates
I tried this but when doing that, the numeric values are not correctly displayed. The user (Who reported me this date format problem) told me that there were problems with sums on numeric columns in Excel when using that Copy / Paste option. I was also able to replicate it myself when it was reported
You can see in the example some of the numbers are left justified, and contain a comma. These are likely being brought in as plain text, and Excel just can’t handle it (without some extra clicks). You can define those fields as all numeric, but you have do it manually in Excel after you paste (look for the drop down that shows up when you paste).
