[Lazarus] DateDif function needed
juergen.hestermann at gmx.de
Sat Nov 9 17:47:20 CET 2013
Am 2013-11-09 16:54, schrieb Michael Van Canneyt:
> On Sat, 9 Nov 2013, Jürgen Hestermann wrote:
>> That would be a real performance hit (i.e. when sorting by date)
>> if you have stored dates in year, month, day... format.
>> Each comparison then needs multiple convertions each time.
> Not if you store everything as a DateTime and use that. The format is such that it sorts naturally.
Storing dates as floats has a lot of drawbacks.
It's inaccurate, you always need a starting date and get other problems.
I shudder when thinking about Excels 1900 and 1904 based dates
where suddenly all my dates in the sheet where changed by 4 years
because the base has changed. ;-(
More information about the Lazarus