Date formats

[Ruslan Zasukhin]

On 5/3/06 10:06 PM, "Joakim Schramm" <joakim at astrocalc.com> wrote:

> Hi,
> 
> Working with the DateTime field type I notices .Value and .GetString returns
> the data and time in different formats as for
> 
> .Value = 31/10/2010 03:00:00

.Value I believe return just numeric values,
   it is VB do some formatting

> .GetString = 2010/10/31 03:00:00:000

GetString execute conversion of numbers into string according to
    current value Vdatabase.DateTimeFormat property.

 
> This is probably as intended were one return the system set date format
> while the other return format set by EVDateFormat as .kYMD in this case. I
> am not an expert on this and I know dates can be tricky. However (and I
> don't know if this is specific to VB), according to a part of the VB
> documentation on "Writing International Code in Visual Basic" the prefered
> format to use in code is #month/day/year# as this is understood correctly in
> all locales. So I would like to raise the question if it wouldn't be better
> to use this format for the Value property, or possibly another property to
> cope with this? As I said, I don't know if this just apply to VB but I
> suspect it would be correctly interpretted in all COM languages at least.

-- 
Best regards,

Ruslan Zasukhin
VP Engineering and New Technology
Paradigma Software, Inc

Valentina - Joining Worlds of Information
http://www.paradigmasoft.com

[I feel the need: the need for speed]