Lotus 5.0

[MMaglet]

When formatting a date in Lotus and selecting date format of 12/21/93 it replaces 013103 on spreadsheet as 11/15/1935. Every date it changes to another date 063003 changes to 06/28/2072.

 

[DaleWatson123321]

Hi MMaglet,

I've created the following formula specifically for your situation. I've tested it and it works.

It's currently set so that any date with a year less than 10 will be treated as a 2000-2099 century date. For example, dates like 063003 will be converted to 30-Jun-2003, and 013103 will convert to 31-Jan-2003

For any dates from 1910 to 1999, the formula will also convert them properly.

Here's the formula...

@DATE(@IF(@VALUE(@RIGHT(A2,2))<10,@VALUE(@RIGHT(A2,2))+2000,@VALUE(@RIGHT(A2,2))),@VALUE(@LEFT(A2,2)),@VALUE(@MID(A2,2,2)))

I hope this helps. Please advise as to how you make out with it.

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

 

[drdebit]

I found this reference earlier this week while trying to research lotus 5 versions.
It is date related - may or may not be useful.
I currently have no way to do any experimenting with it.

http://www.support.lotus.com/csserv.nsf/linkfr/y2kupdates