Hi - we're using the queryHelper plugin in ColdBox and have made use
of the getCSV() method to convert some of our report queries to CSV.
This is working great in general with the exception of date fields.
We're in the UK, so we display dates in UK date format (dd/mm/yy),
however the getCSV() method in queryHelper is formatting any columns
that have the word "date" in them using the US centric dateFormat()
function.
This has the unfortunate result of mangling our data due to the way
that dateFormat works, so I end up with results like this:
date,totalnum
07-Oct-11,0
07-Nov-11,0
07-Dec-11,2
13-Jul-11,0
14-Jul-11,0
15-Jul-11,1
instead of
date,totalnum
10-Jul-11,0
11-Jul-11,0
12-Jul-11,2
13-Jul-11,0
14-Jul-11,0
15-Jul-11,1
LSDateFormat() would be better to use here. I know as a workaround, I
can just ensure that my column name in the query result doesn't
include the word "date" in it, but this should probably be optional
anyway (what if I have a field called "consolidated" or something).
Cheers,
Colin.