Datediff differences in US and Europe

[jda]

On Jun 28, 2012, at 12:43 PM, Robert Brenstein wrote:

> On 27.06.2012 at 10:07 Uhr -0400 jda apparently wrote:
>>
>> It fails if the language is set to German. I thought
>>
>>     01-01-1904
>>
>> would work, but the search -> no results (there should be many when  
>> the language is German (or English).
>
> Actually, in Germany, such a date would normally be written 01.01.1904
> Also, don't forget that the month and day are swapped.
>
> Since I can change the format and the order of items as I wish on my  
> Mac, you either need to use a standardized input format or be able  
> to parse current user settings (unless now() does it for you).

Ah, you're right. Using

      01.01.1904

works for German settings.

Interestingly, for French and Italian the same setting works as for  
the US:

      01/01/1904

Thanks.

Jon