InfoPath Dev

1. When the form loads I would like the dates to be listed in sequential order from old to new.  Right now users can enter dates randomly and the entries remain in that order.
2. On another view I have drop-down filter that searches the repeating table by the date picker field.  My problem is the date is in the drop-down list reads as yyyy-mm-dd, but I would like it to read mm/dd/yyyy.  The date picker format is mm/dd/yyyy.  Can this be done?

Any help would be greatly appreciated.

For #1, if your form does not have code, you can inject it with qRules and use the SortTable command to sort your rows according to the dates. Otherwise, I believe you'll need to write your own code.

For #2, for the date picker you can change the way the date is displayed, but the xml stores it a different way. Then the dropdown will display it the way it is stored in the xml. You might be able to translate the stored xml date via rules. I'm not sure of the exact rules needed, though...