Date format for sorting

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

Dear friends, 

We have a problem when passing data type date. The programming
environment in which we work is not Visual Basic. Therefore, it is not
100% compatible with the data types of Visual Basic. 

 The
problem is the compatibility with the Variant type. When passing data
to the Report Control, interprets it as text and not as a date. We know
this because the cell formatting, or does not interpret the format. 

 The question is: Is it possible after passing the data as text, change the data type to date? 

 Thank you very much in advance!

Author	Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic
DavidSpain Members Profile Send Private Message Find Members Posts Add to Buddy List Newbie Joined: 18 March 2009 Status: Offline Points: 7	Post Options Post Reply Quote DavidSpain Report Post Thanks(0) Quote Reply Topic: Date format for sorting Posted: 14 April 2009 at 6:04am
	Dear friends, We have a problem when passing data type date. The programming environment in which we work is not Visual Basic. Therefore, it is not 100% compatible with the data types of Visual Basic. The problem is the compatibility with the Variant type. When passing data to the Report Control, interprets it as text and not as a date. We know this because the cell formatting, or does not interpret the format. The question is: Is it possible after passing the data as text, change the data type to date? Thank you very much in advance!

Aaron Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 29 January 2008 Status: Offline Points: 2192	Post Options Post Reply Quote Aaron Report Post Thanks(0) Quote Reply Posted: 15 April 2009 at 4:47am
	Hi, If you would assign value like this: rec.AddItem(CDate("15-4-2009")) I don't know what language you use... but somekind of Date type should not be a problem...
	Product: Xtreme SuitePro (ActiveX) version 15.0.2 Platform: Windows XP (32bit) - SP 2 Language: Visual Basic 6.0 Zero replies is not an option....

mdoubson Members Profile Send Private Message Find Members Posts Add to Buddy List Senior Member Joined: 17 November 2008 Status: Offline Points: 1705	Post Options Post Reply Quote mdoubson Report Post Thanks(0) Quote Reply Posted: 01 May 2009 at 5:12pm
	Use specific report record item type and it will propely sorted - not as simple string