Solved

Lotusscript - Datelist problem

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

Independent Software Vendors: 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 Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
This video Micro Tutorial shows how to password-protect PDF files with free software. Many software products can do this, such as Adobe Acrobat (but not Adobe Reader), Nuance PaperPort, and Nuance Power PDF, but they are not free products. This vide…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…

726 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