Datediff differences in US and Europe

[Bart Pietercil]

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

regards 

-- 
Bart Pietercil
CTO Cognosis NV
Dorpstraat 28
3560 Lummen


On Friday 29 June 2012 at 15:47, Robert Brenstein wrote:

> On 29.06.2012 at 8:50 Uhr -0400 jda apparently wrote:
> > What is "now" for Valentina on a Mac. Is it the seconds after 
> > 1/1/1904 (which is how Macs deal with dates)? This is why we had the 
> > problem in the first place, because we had to subtract the date 
> > 1/1/1904 from now() to do the comparison.
> > 
> 
> 
> Hmm, if you are looking only at a difference between two dates, their 
> reference date (1904 or 1970) is irrelevant as long as both dates use 
> the same. But you probably need to display them in human-readable 
> form at some point.
> 
> If you are working on a single platform, you could store dates as 
> seconds (that is unix time) to make things simpler. I often store 
> them in parallel as seconds and datetimeitems (y,m,d,h,m,s,t), former 
> for calculations and latter for easy inspection and display, or as 
> yyyymmdd depending on the project. Storing as date/time fields is the 
> most headache usually.
> 
> Robert
> _______________________________________________
> Valentina mailing list
> Valentina at lists.macserve.net (mailto:Valentina at lists.macserve.net)
> http://lists.macserve.net/mailman/listinfo/valentina
> 
> 


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120629/b6ae763b/attachment.html>