Report Control - Date format for sorting

Print Page | Close Window

Date format for sorting

Printed From: Codejock Forums
Category: Codejock Products
Forum Name: Report Control
Forum Description: Topics Related to Codejock Report Control
URL: http://forum.codejock.com/forum_posts.asp?TID=14005
Printed Date: 14 November 2024 at 11:24pm
Software Version: Web Wiz Forums 12.04 - http://www.webwizforums.com

Topic: Date format for sorting

Posted By: DavidSpain
Subject: Date format for sorting
Date 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!

Replies:

Posted By: Aaron
Date 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....

Posted By: mdoubson
Date Posted: 01 May 2009 at 5:12pm

Use specific report record item type and it will propely sorted - not as simple string

-------------
Mark Doubson, Ph.D.