Solved

Lotusscript - Datelist problem

Posted on 2007-04-10
5
223 Views
Last Modified: 2013-12-18
Hi all,

I am calculating a datelist based on a startdate, enddate and a life cycle.
The list is calculated but I get the following date appended at the end of the list 30/12/1899
For example, the list will be:
10/01/2007, 10/02/2007, 10/03/2007, 10/04/2007, 30/12/1899

And the date obviously appears as the first date in the view when I have the view sorted descending by date.

Any ideas will be greatly appreciated.

varvoura
0
Comment
Question by:varvoura
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
5 Comments
 

Author Comment

by:varvoura
ID: 18881687
Strange,
As long as the life cycle of the difference between startdate & enddate is less than 5 years the 30/12/1899 does not appear on the datelist.
1or 2 or 3 or 4 years life cycle(which is the difference between startdate & enddate)  is OK, but when I include 5(for 5 years) in that field 30/12/1899 is appended at the end of the list.
0
 

Author Comment

by:varvoura
ID: 18881720
More...

How many entries can a multi-value datetime field handle?
0
 

Author Comment

by:varvoura
ID: 18882298
while testing, I have noticed that when the multi-value date field(datelist) has over 120 entries then 30/12/1899 is appended at the end.
Now, does anyone have an idea why? is there a restriction on a date field size?
0
 
LVL 63

Accepted Solution

by:
SysExpert earned 250 total points
ID: 18882507
This may be a bug or a feature.

What version of Notes client and server are being used ?

Are you sure that these are not conversion errors from blank input or similar ?

I hope this helps !
0
 

Author Comment

by:varvoura
ID: 18888828
Hi SysExpert,

Domino 7 & notes 6.5

I have modified the script which calculates the date list a bit and it seems to have resolved the problem

Many thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

For users on the Lotus Notes 8 Standard client, this article provides information on checking the Java Heap size and adjusting it to half of your system RAM in attempt to get the Lotus Notes 8.x Standard client to run faster.  I've had to exercise t…
For beginners of Lotus Notes user this is important to know about the types of files and their location supported by IBM Notes. Mostly users are unaware about how many file types are created and what their usages are. This Article is fully dedicated…
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an antispam), the admini…

737 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question