Re: Strange date2unix() behaviour



On Tue, Apr 02, 2002 at 06:09:49PM -0800, Lars Torben Wilson wrote:
I have a date, formatted as Date->/m/d/y h:mm. It's in cell A5. The date
entered there is '3/26/02 10:30'. So far, so good.

In another cell I have '=date2unix(a5)'. Formatting for this cell
is 'Text'. However, the value which it is showing is this:

  1017129600.4375

...which is bizarre since Unix timestamps are integers, not floats. The
weird thing is that this *does* round-trip; i.e. if I unix2date() this
value, I get the original date back.

This was fixed in both trees.



[Date Prev][Date Next]   [Thread Prev][Thread Next]   [Thread Index] [Date Index] [Author Index]