EnterpriseMobileToday PDAStreet

Home | News | Reviews | Features | Tips | Mobile Product Watch | Forums
PDAStreet.com: Message Boards: HP 200LX: Re: Lotus 123 - I can't work with DATES - Help-me!

Re: Lotus 123 - I can't work with DATES - Help-me!

You are looking at Message Board Archives!
Please access our new message boards at http://www.pdastreet.com/forums/ .

Post Reply | Read Replies | Start New Thread | HP 200LX Board Index

HP 200LX Board (Del Msg)
Title: Re: Lotus 123 - I can't work with DATES - Help-me!In Reply To
Posted By: JamesTitle: Lotus 123 - I can't work with DATES - Help-me!
E-mail: jamesebl@lineone.netPosted By: Paulo Masetti
Date: 01/03/2002 at 08:50:29Date: 01/01/2002

Message:

HP200LX version of 123 seems to be partially Y2K compliant.

It doesn't like inputting dates as dd/mm/yy or whatever - you have to use 123 version 4 or above for this, I think. You have to use the @date function, which counts forward from 1 Jan 1900.

On my LX in Lotus:
1/3/2002 returns a fraction 0.0001665002...
@date(2002,1,3) returns ERR
@date(102,1,3) returns 37259, the date number for 3 Jan 2002. Format this as usual to get it to echo the date - "Lotus Standard Long Form" will echo as 03-Jan-2002 (UK style).
@date(2,1,3) returns 734. This is the date number for 3 Jan 1902, and may work for you or not depending on what you want to do. If you format the cell to "Lotus Standard Long Form" it will echo 03-Jan-02
If you get ***** make the column wider - Lotus must echo years from 2000 on as 4 digits, even though it echoes dates up to 1999 as 2 digits.

In other applications, the (Fn-,) shortcut works fine, although on my machine it generates a date field in dd-mm-yy format (two digits only for the year).

Can't see why backing up the machine should cause a fault with Lotus - it's burnt in to the chip and should not be capable of being overwritten.

Hope this helps.





Is this message offensive or in violation of this board's policies? If so report it by clicking here.

Message Thread

Post Reply

 

For Additional Information:

Latest Articles:

  • Blackberry Email Snafu Fixed, RIM Says
  • Windows Mobile 7 Due Late Next Year?
  • Android Passes the 20,000 Apps Mark
  • Gartner Says Mobile Device Sales Flat in 2009
  • AMD Sets May Date for Mobile 'Danube' CPUs
  • AT&T Ready to Give a Little on Net Neutrality?
  • CTIA Looks Ahead on 2010 Agenda Plans
  • Intel Merges GPU, CPU for Netbooks
  • Bing Makes Its iPhone Debut
  • Cisco Closes $2.9B Starent Acquistion
  • Latest Downloads:

  • OST to PST Outlook Converter 5.0 (Other)
  • Erase Files 11.04.01 (Other)
  • Outlook to Notes Tool 8.07.01 (Other)
  • Free OST Converter 5.0 (Other)
  • Offline EDB to PST 5.3 (Other)
  • Backup Data Recovery 8.05.01 (Other)
  • File Eraser 11.04.01 (Other)
  • Exchange Email Recovery 11.05.01 (Other)
  • MDF File 11.12.01 (HP200LX)
  • PowerPoint Recovery 10.11.01 (Other)