I have a problem with a Calendar view.If the Calendar view is by month, I can see all the documents. But when I switch to ‘week’ or ‘day’ I don’t see any document.
The strange thing is that the documents in the view before July 26 2004 are correctly shown but all after July 26 I can’t see them.
The problem just started last week - before that time it worked perfectly!
How it is constructed :
The first column is (hidden ‘Time and Day’) can contain multiple values with following notation : @TextToTime(T_MultipleDay).
The second column (hidden ‘Duration’) always contains a default duration (“00:00:00”)
Hopefully someone can give me the answer to this problem because over 200 employees are working with these views - thank you
Subject: Calendar view Month versus Week and Day
In general, it is always a bad idea to store date/time values in text fields, since the conversion back to date/time is dependent on the date format being the same. Date/time values should always be stored in date/time type fields. Possibly this is the root cause of your problems.
Try looking at the T_MultipleDay field, comparing values on documents before July 26 2004 with values after that date, to see if the date format has somehow changed.
Subject: RE: Calendar view Month versus Week and Day
I checked out the dates by putting them in a simple view, but none of theme seems to be corrupt or in another format.
Maybe it will help to explain the composition of het field T_MultipleDay in the form :
I have two editable fields with type Date/Time (T_StartDate and T_DueDate).
T_MultipleDay is a computed field with type Date/Time. ‘Allow multiple values’ is checked.
The formula for this field :
Duration:=@TextToTime( @Text(T_StartDate)+“-”+@Text(T_DueDate) );
@Explode(Duration)
Hopefully this will help us to find a solution.
Subject: It might help if you posted the values of T_MultipleDay.
Check Doc Properties and copy and paste the values.
Subject: RE: It might help if you posted the values of T_MultipleDay.
here are some values of T_MultipleDay :
Document 1 :
“26/07/2004”
Document 2 :
“01/07/2004”
“02/07/2004”
“03/07/2004”
… until
“31/07/2004”
Subject: Are you sure your server has the same regional settings “dd/mm/yyyy” that your client does?