Export to Excel - only want date, not date/time to appear in date field
Content
I have tried about 5 different ways to format the dates in a report I have created and then export that date to be the date only with no timestamp in Excel.
No matter how I format the date with the date_format() or trunc() or whatever I do to get just the date in the report, I can't get Excel to show it as a date field. If I don't check the box on the Export pop-up to "Convert all dates into Excel formatted dates" the date appears as text in Excel so the person who is trying to import that into another program gets an error because it's not formatted as a date. When I view the format of the field, it shows in the "Custom" category as m/d/yyyy h:mm (even
Tagged:
0