Datediff differences in US and Europe

[Jonathan Ashwell]

Ruslan,

Please read my posts again, carefully.

I do NOT use Valentina date and time fields, I use my own fields (doubles) and save the Mac date and time data.

It works, and has for many years.

I've been using an SQL search that let's me get records entered after a relative date:

datediff( now(), '01/01/1904', 'seconds')

and it works for Engish! But the *stupid* function is language sensitive, so

     '01.01.1904'

is required if the language is German.

And God knows what it is for Russian!

I want a simpler way to always get what I want without worrying about the language.

If Valentina can't do this, just tell me.

Jon
Sonny Software




> 
> > 
> > The dates and times are stored as ulongs
> 
> right
> 
> > (as Mac dates).
> 
> Wrong
> 
> There is no any MAC or WIN here.
> 
> DATE and TIME values are converted into
>   format-independent  ULONG - 32bit value.
>        
> We do not use any "relative to some magic date" tricks.
> 
> DATE is stored as is. ABSOLUTE value.  30 June 2012.
> Yes, this means in the current our calendar.
> 
> 
> 
>  
> > Jon
> > 
> > 
> > 
> > 
> >                 
> >                     It was my understanding that Valentina ALWAYS
> >                     stores date
> > time information as raw unformatted numbers. Hence my reference  to
> > the
> > to_days and to_secs functions
> > As always, I might be wrong
> 
> --
> 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]
> 
> 
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net
> http://lists.macserve.net/mailman/listinfo/valentina
>