How to change the way a date is formatted in an export in CommCare

The default settings of your project do not let you split mulitselect questions in case exports. This is because your case does not know which questions correspond with which case properties (because it could be multiple questions).

However, we do have a feature preview that you can enable on your project that will allow you to define how you would like to split your case property in a case export.

You can enable this setting by going to https://www.commcarehq.org/a/your_domain/settings/project/previews/ and checking the "Split multi-selects in case export" option. Then hit Update Previews.

When that is enabled you should see an extra column in your export that will allow you to select the Type. Here you select "multiselect." Then you can add your options. Example below:

The ordering of the date fields (day, month, year) is actually determined by the default language settings on your phone. To get the dates to appear as MM/DD/YYYY, go to the Android Settings -> Language & Input and set the Language to "English (United States)". To get the dates to appear as DD/MM/YYYY, go to the Android Settings -> Language & Input and set the Language to "English (United Kingdom)". For languages other than English, you may need to try out different regional language settings to find the right choice.