Support Forums - View Thread

View Thread

The following is the text of the current message along with any replies.

Messages 1 to 4 of 4 total

Thu, Apr 19 2012 7:17 PM	Permanent Link
Gerald J. Clancy, Jr.	DBISAM Stupid question time: What date format should be used in the range values of a SetRange when the underlying index field is a TDateTime? TDateTime values of ANSI type dates (e.g., "2010-04-19")? Jerry
Fri, Apr 20 2012 7:00 AM	Permanent Link
Jose Eduardo Helminsky HPro Informatica	Jerry You need to convert from string to TDateTime (using the current locale) before the range Eduardo
Tue, Apr 24 2012 10:19 AM	Permanent Link
Tim Young [Elevate Software] Elevate Software, Inc. timyoung@elevatesoft.com	Jerry, << Stupid question time: What date format should be used in the range values of a SetRange when the underlying index field is a TDateTime? TDateTime values of ANSI type dates (e.g., "2010-04-19")? >> Just using StrToDate() should work fine. The ANSI date/time format is only required for SQL/filter expressions. -- Tim Young Elevate Software www.elevatesoft.com
Wed, Apr 25 2012 8:06 PM	Permanent Link
Gerald J. Clancy, Jr.	Thanks Tim and Eduardo. TDateTime is what I am using, so this is good news. Sorry for the delay in response. Jerry "Tim Young [Elevate Software]" <timyoung@elevatesoft.com> wrote in message news:AA3BBB70-AFB8-429B-BE6D-4A226DB83603@news.elevatesoft.com... > Jerry, > > << Stupid question time: What date format should be used in the range > values of a SetRange when the underlying index field is a TDateTime? > TDateTime values of ANSI type dates (e.g., "2010-04-19")? >> > > Just using StrToDate() should work fine. The ANSI date/time format is > only required for SQL/filter expressions. > > -- > Tim Young > Elevate Software > www.elevatesoft.com