HOWTO: Format date/time values

I am adding some date/time values as CXTPReportRecordItemDateTime items and I would like to format the date and time string displayed in the cell.  How do I do this?

Using Column->SetFormatString() with a string such as "dd/MM/yyyy HH:mm:ss" (the value from GetLocaleInfo()) doesn't do the job.

Product: Xtreme Toolkit Pro (MFC) version v15.0
Platform: Windows XP (32bit) - SP 3
Language: VC++ 2010

Thanks for the answer.

My mistake, SetFormatString() is on the item not the column.

The documentation for the method is incorrect here.  CXTPReportRecordItem::SetFormatString says to look at the sprintf format specifications whereas for CXTPReportRecordDateTimeItem::SetFormatString I should be looking at the strftime format specifications.  The sprintf format specifications don't actually have any codes for dates or times.

Unfortunately it looks like it's going to be tricky to use the user's/system preferences to do the formatting since this would require translating from one format specification to another.