"Date format" conflict between iMac and iPhone

hi all,

Using Apple Numbers for iCloud. By referring to a previous date such as "Jan 17, 1994" in the formula DATEDIF("1/17/1994";now();"D"), the result

in the iMac is Ok and in the iPhone is ERROR.

But in changing the "date format" in the same formula like DATEDIF("17/1/1994";now();"D"), the result in the iMac is ERROR and in the iPhone is Ok.

Thanks for any help

iMac (21.5-inch Mid 2011), OS X Mavericks (10.9.3)

Posted on Mar 21, 2016 4:30 AM

Reply
1 reply

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

"Date format" conflict between iMac and iPhone

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.