<html><body style="word-wrap: break-word; -webkit-nbsp-mode: space; -webkit-line-break: after-white-space; "><br><div><div>The dates and times are stored as ulongs (as Mac dates).</div><div><br></div><div>Jon</div><div><br></div><div><br></div><div><br></div><div><br></div><blockquote type="cite"> <div> 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 </div><div>As always, I might be wrong</div><div><br></div><div>regards</div> <div><div><br></div><div>-- </div><div>Bart Pietercil</div><div>CTO Cognosis NV</div><div>Dorpstraat 28</div><div>3560 Lummen<br></div><div><br></div></div><p style="color: #A0A0A8;">On Friday 29 June 2012 at 15:47, Robert Brenstein wrote:</p> <blockquote type="cite" style="border-left-style:solid;border-width:1px;margin-left:0px;padding-left:10px;"> <span><div><div><div>On 29.06.2012 at 8:50 Uhr -0400 jda apparently wrote:</div><blockquote type="cite"><div><div>What is "now" for Valentina on a Mac. Is it the seconds after </div><div>1/1/1904 (which is how Macs deal with dates)? This is why we had the </div><div>problem in the first place, because we had to subtract the date </div><div>1/1/1904 from now() to do the comparison.</div></div></blockquote><div><br></div><div>Hmm, if you are looking only at a difference between two dates, their </div><div>reference date (1904 or 1970) is irrelevant as long as both dates use </div><div>the same. But you probably need to display them in human-readable </div><div>form at some point.</div><div><br></div><div>If you are working on a single platform, you could store dates as </div><div>seconds (that is unix time) to make things simpler. I often store </div><div>them in parallel as seconds and datetimeitems (y,m,d,h,m,s,t), former </div><div>for calculations and latter for easy inspection and display, or as </div><div>yyyymmdd depending on the project. Storing as date/time fields is the </div><div>most headache usually.</div><div><br></div><div>Robert</div><div>_______________________________________________</div><div>Valentina mailing list</div><div><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a></div><div><a href="http://lists.macserve.net/mailman/listinfo/valentina">http://lists.macserve.net/mailman/listinfo/valentina</a></div></div></div></span> </blockquote> <div> <br> </div> _______________________________________________<br>Valentina mailing list<br><a href="mailto:Valentina@lists.macserve.net">Valentina@lists.macserve.net</a><br>http://lists.macserve.net/mailman/listinfo/valentina<br></blockquote></div><br></body></html>