Codejock Developer Community : HOWTO: Format date/time values

HOWTO: Format date/time values : On further investigation,...

Tue, 12 Apr 2011 05:24:57 +0000

Author: RichardJ
Subject: 18203
Posted: 12 April 2011 at 5:24am

On further investigation, the formatting code %c respect's the user's settings.

HOWTO: Format date/time values : Thanks for the answer.My mistake,...

Tue, 12 Apr 2011 05:12:36 +0000

Author: RichardJ
Subject: 18203
Posted: 12 April 2011 at 5:12am

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.

HOWTO: Format date/time values : Hi;I do it this way: Item=AddItem(new...

Mon, 11 Apr 2011 15:52:57 +0000

Author: mgampi
Subject: 18203
Posted: 11 April 2011 at 3:52pm

Hi;
I do it this way:

   Item=AddItem(new CXTPReportRecordItemDateTime(COleDateTime(Date)));
    Item->SetFormatString("%d.%m.%Y");

I can't find a SetFormatString() function in CXTPReportColumn class?!?!

HOWTO: Format date/time values : I am adding some date/time values...

Mon, 11 Apr 2011 09:31:06 +0000

Author: RichardJ
Subject: 18203
Posted: 11 April 2011 at 9:31am

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