Date Format change
In our system settings we have the date format as MM/dd/yyyy - typical US settings. However, when I look at various reports (Sales, Inventory, Purchase Orders etc) the date format is dd/mmm/yyyy.
Today is July 16 2021. That should report as 07/16/2021. However when viewing reports and exports, it shows as 16-JUL-2021. The format has been rearranged AND the / have been changed to -
16-JUL-2021 doesn't sort or pivot in Excel. I should not have to write a formula to change the date so I can use the data from DEAR for analysis.
Please have all the dates match what we have defined in our system settings!
Yes. we have same situation and requirement.