Change the Order of Data Formats

You can modify the cogformat.xml file to change the order in which data formats are presented in Query Studio.

For example, in your locale, the dates might be presented in the following order:

19/12/03
19-Dec-03
December 19, 2003
Friday, December 19, 2003

If your users are most likely to choose the last date format, you might want it to appear first on the list of dates.

Procedure

In the cogformat.xml file, locate the data format for the locale that you want to modify. For example, the following XML code defines the order of date formats for the en-CA (English Canadian) locale:

...
<formatList name="qsdates" xml:lang="en-CA">
  <dateFormat dateStyle="short">19/12/03</dateFormat>
  <dateFormat dateStyle="medium">19-Dec-03</dateFormat>
  <dateFormat dateStyle="long">December 19, 2003</dateFormat>
  <dateFormat dateStyle="full">Friday, December 19,
2003</dateFormat>
</formatList>
...

To change the order in which data formats appear in Query Studio, rearrange the order of the code. For example, to have Friday, December 19, 2003 appear as the first date format, change the XML code as follows:
```
...
<formatList name="qsdates" xml:lang="en-CA">
  <dateFormat dateStyle="full">Friday, December 19,
2003</dateFormat>
  <dateFormat dateStyle="short">19/12/03</dateFormat>
  <dateFormat dateStyle="medium">19-Dec-03</dateFormat>
  <dateFormat dateStyle="long">December 19, 2003</dateFormat>
</formatList>
...
```
The dates are now presented in the following order in Query Studio:
- Friday, December 19, 2003
- 19/12/03
- 19-Dec-03
- December 19, 2003