Login ProductsSalesSupportDownloadsAbout |
Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General » View Thread |
Messages 1 to 4 of 4 total |
Date values in SetRange |
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 |
This web page was last updated on Wednesday, April 24, 2024 at 11:07 AM | Privacy PolicySite Map © 2024 Elevate Software, Inc. All Rights Reserved Questions or comments ? E-mail us at info@elevatesoft.com |