Date Formats in Exported Excel Files
I've had a user complaining that when they export a discovery to Excel, they are unable to filter on date columns- normally in Excel when filtering dates, they are grouped together by year, month etc, but in exported Pyramid files the dates show individually as text -see the picture
I have tried changing the date formats in my model but no matter what I do, the dates won't filter properly in the exported Excel file- is there a particular date format I should use that I haven't tried, or is it not possible?
Hi, wondering if anyone has an answer to this please? User is asking again!