Datediff differences in US and Europe

[jda]

On Jun 28, 2012, at 8:56 AM, Bart Pietercil wrote:

> Wouldn't a combination of to_days(date) en from_days(ulong) help ?
> Using from_days(some number equal to the date you need) is always  
> correct no matter what date time format is used.
> This is what we did when trying to escape hardcoding dates.
>
> hth
>

Hm, interesting. Can you give an explicit example of how you'd do this  
(given that the record has stored the date added in seconds since Jan  
1, 1904, the standard Mac OS X reference date)?

Thanks,

Jon