Datediff differences in US and Europe

[jda]

Hi Ruslan,

I have a method that uses datediff to determins if a record was  
created in the last 2 weeks:

      dateAdded > datediff( now(), '01/01/1904 00:00:00', 'second' ) -  
(14 * 24 * 60 * 60)

This works well on US Macs.

You told me to use

       dateAdded > datediff( now(), '01-01-1904 00:00:00', 'second' )  
- (14 * 24 * 60 * 60)

for European systems. I checked this by changing my settings to German  
(in the International System Preferences). But not neither search works.

So, what should I use for the day, month, and year for different  
regions?

Thanks,

Jon
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.macserve.net/pipermail/valentina/attachments/20120627/c3399a10/attachment.html>