Looks like no one’s replied in a while. To start the conversation again, simply ask a new question.

"Now" always returns Jan 1 of current year

When manually entering data into a Numbers field with the type defined as Date/Time and Hour part selected and you select "NOW", you get the current time, but the date part is always Jan 1 of the current year.


Is there a way when selecting Now for it to automatically use the current date, not Jan 1 (don't want to manually key in the date each time). I use formulas to calculate time diff and it will not work correctly when you cross days.


Thanks,

Robert

iPad 2, iOS 5.0.1

Posted on Feb 1, 2012 4:11 PM

Reply

There are no replies.

"Now" always returns Jan 1 of current year

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