Hi Roger

I can't think of a way that this could be controlled inside Sage CRM.  The dates arrive in the Excel spreadsheet looking like ="06/27/2025 7:00 pm"

A VBA (Visual Basic for Applications) macro can be written to scan a newly created spreadsheet for any columns containing data that looked like ="06/27/2025 7:00 pm" and then convert that to a date value.

VBA Macros can be made to run independently of a specific spreadsheet by adding to a Personal Macro Workbook so it's always available.

I don't have enough familiarity with VBA to do this myself.  

Many thanks. May just add a custom field into the report view that sets the date to yyyy-mm-dd format. At least that will be easy to do and be sortable..

Or you could do it as a TRY_CONVERT(datetime,<<date field>>,103) which will result in dd/mm/yyyy only

Or you could do it as a TRY_CONVERT(datetime,<<date field>>,103) which will result in dd/mm/yyyy only