Solved

Lotusscript - Datelist problem

Posted on 2007-04-10
5
220 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
  • 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

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

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

You’ve got a lotus Domino web server, and you have been told that “leverage browser caching” is a must do. This means that we have to tell the browser everywhere in the web to use cache. In other words, we set (and send) an expiration date in the HT…
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
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…

773 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