Hi AllI am having a problem with Calendar entries showing on wrong date. Has anyone seen this before. This only started when we past 12/31/2007. I have looked over the forum and can’t find anything on this. I have looked over everything in the database, and couldn’t find any problems. If anyone has any pointer I would be glad to try them.
Phillip
Subject: Calendar entries showing on wrong date
Is there a pattern for wrong dates? Like, are they wrong by fixed number of days or is it random?
regards
Litty Joseph
Subject: Calendar entries showing on wrong date
Phillip, This is sometimes a problem in relation to daylight saving, but that should not be the problem you are having.
Is this all users? one user and one calendar? or one calendar many users? Each users daylight saving settings should match if using a shared calendar or something I put in can appear on a different (or multiple) days if it is an all day event. i.e everyone should be following OS or everyone calculating in Client.
These may help point you somewhere but I can only guess from the info you have posted so far, a few more details and someone will be able to help more.
Ian
Subject: RE: Calendar entries showing on wrong date
It is happen to only to 4 users. Daylight saving time is not the problem. I have checked the PCs. I can submit an entry placing their name on the form and it will still show the entry as much as 4 to 5 month ahead. I an no a beginner to Lotus Notes. This problem has stumpped me. Let me know if you think of anything.
Thank you for the replies
Phillip
Subject: RE: Calendar entries showing on wrong date
It sounds to me someone is storing the dates as text and converting them back to dates for use in the calendar. Without more details (e.g. the view column formula that calculates the date, the actual values in the fields of the problem documents) it’s hard to be more specific, but there are three systems whose date/time settings might be relevant:The workstation of the user who created (or last edited) the document.
The server.
The workstation of the user opening the calendar view.
A problem may occur if the date formatting settings of any of these systems is different from those of another. The details depend on the details of the application. For instance, say the author’s workstation is set to dd/mm/yyyy, and they select January 4, which is stored in the field StartDate as the text string “04/01/2008”. The view column has the formula @TextToTime(StartDate), but if the server replica of the database is used, the server evaluates this formula. The server is set to format dates as mm/dd/yyyy, so it interprets the text string as 1 April 2008.
The reason this started showing up after the new year, is that the date interpretation is fairly clever about swapping things around to make the date make sense. “22/12/2007” is always understood to mean 22 December because 22 is not a valid month number.
The solution to this is to never, ever, ever store dates as text strings.
Subject: RE: Calendar entries showing on wrong date
Phillip
I only have more questions at this point to clear up in my mind the problem.
Is it a Calendar from a Lotus Template or an inhouse application?
This problem can occur from any PC?
This problem can occur from any user entering the data?
The only common feature is putting any of 4 user names in the form with always create the problem?
How do you select the user name to put in the form?? from a NAB, a coded list or free typing??
Which form is it??
What calculations are done on the date based on the name??
Have you stepped through this with debug on to see what is being changed and at what point?? (for both a good and then a bad entry!)
You will then know what is being changed and when, if not why!
Ian