Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Working with time

Status
Not open for further replies.

danrad

Technical User
Feb 24, 2002
3
US
I am looking for a fix on displaying time in a listbox. Problem is Lotus displays the decimal time and not the formatted time. Anyone have any suggestions on a fix. Thanks
 
danrad,

I'm not sure this will be an "exact" fix - however, it might be worth taking a look at.

The "command" I'm about to suggest comes from the "old macro programming language" (which I call "SNAP" - for Super Natural Application Programming - FAR superior language than LotusScript or Visual Basic).

The command, if I recall (I don't have Lotus 123 here at work) is the "{CONTENT}" command, which allows for conversion of a cell's contents to "text" - in the same format. Hopefully, the same command, or a similar version is part of LotusScript, or perhaps LotusScript will still recognize the SNAP commands.

Hope this helps. If I expected a "flood of responses", then I would not have bothered with this suggestion, because others would have probably come up with a better suggestion. However, in checking this Lotus 123 forum on a regular basis, I don't see too much "activity".

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top