Datediff differences in US and Europe

[jda]

The dates and times are stored as ulongs (as Mac dates).

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
>
> 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
>> http://lists.macserve.net/mailman/listinfo/valentina
>
> _______________________________________________
> Valentina mailing list
> 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/671423d9/attachment-0001.html>