Skip navigation

"Now" always returns Jan 1 of current year

172 Views 0 Replies Latest reply: Feb 1, 2012 4:11 PM by rbeckmann RSS
rbeckmann Calculating status...
Currently Being Moderated
Feb 1, 2012 4:11 PM

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

Actions

More Like This

  • Retrieving data ...

Bookmarked By (1)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.