Date Format change

started a topic over 2 years ago

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!

1 person likes this idea
  • Yes. we have same situation and requirement. 

Login or Signup to post a comment

1 person likes this idea
Log in or Sign up to post a comment