CF9/10 CFSpreadsheet Dataformat Test

Preferred date format: "m/d/yy h:mm"
Problem: Query date/times not properly formatted when converting to Excel.
Data Format:
"built-in" Date formats
m/d/yy
d-mmm-yy
d-mmm
mmm-yy
h:mm AM/PM
h:mm:ss AM/PM
h:mm
h:mm:ss
m/d/yy h:mm
mm:ss
[h]:mm:ss
mm:ss.0