KB269224: How to change default date format on grid in MicroStrategy Web 10.1

If Intelligence Server is running under a Windows system account, users can follow the steps in KB221404 to change the default date format.
 
If Intelligence Server is deployed on Linux, users can follow the steps below to customize the date format to “YYYY-MM-DD” (the method also works for Windows environment):
 

• Edit the Date attribute and create a new attribute form.
• Use ApplySimple in the form expression and change the date format to yyyy-mm-dd. Expression:
  ApplySimple("FORMAT(#0,'yyyy-MM-dd')", [DAY_DATE])
  
  

• Save the modification and update schema.

Note:  
The form expression in the above sample is for Access database only. Users need to change the expression accordingly based on the database being used.
Reference:
KB3905: How to use pass-through expression- ApplySimple in Strategy SQL Generation Engine 9.x