Exporting dates when using Report Designer or Inquiries

When I export a report to Excel using a Report Designer report or from in Inquiry the dates always export as text.  Is there any way to have them format as a date? 

  • 0

    Thanks for your post !

    What version and update of Sage 300 CRE are you currently using? That will help other users compare their designs/version to yours. I'm also going to push this out through our Twitter channel to broaden the scope of your question!

    Can't wait to see what others have tried!

  • 0

    We're vs. 13.1 and have not had luck printing as an Excel file as most reports will merge cells, etc. which creates other problems.  We've had better luck printing from Sage 300 CRE as a text file (.txt) and then starting Excel (and while showing all files types) opening the *.txt file with Excel.  With this method you can make the dates format as dates.  It does take a little work as you have to move columns, etc. but in the end, it does work.  You can then save the *.txt file as an Excel file once you've opened it with Excel.