I am confused on how to correctly set the first column of a calendar view. An event with several days’ span cannot be displayed correctly.
For example, a user’s vacation which starts on July 2, 2008, to July 3, 2008.
The first two columns in the view are : StartDate and End Date.
I put EndDate value to the second column.
The problem happens on the first column:
If I put StartDate value for first column, which is the single date value( 02/07/2008 ), vacation in calendar shows only one day, that is on start date 02/07/2008. The row which is for 03/07/008 shows nothing.
If I put a date list value ( 02/07/2008, 03/07/2008 ) to first column, the view display the vacation for three days: 02/07/2008, 03/07/2008, and 04/07/2008.
Please advise. Thanks!
Subject: I seem to remember you have to have time too. Otherwise calendar views can act funky.
Subject: It is OK now, but still looked weird
OK now, here is what I did:
(1) I am using:
@TextToTime( @Text(DateList) + “12:00 PM” )
Instead of : @TextToTime( @Text(DateList) + " 12:00 PM" )
in End Date column, which is the second column, and it is must “General” type!!!
(2) I am using:
@TextToTime( @Text(DateList) + " 12:00 PM" )
in Start Date column, which is the first column, and it is “Date/Time” type.
The following doesn’t work:
@TextToTime( @Text(DateList) + “12:00 PM” )
View displays normally.
I feel weird. Don’t understand why (1) has to be that way. Anything wrong from my side?
Subject: RE: I seem to remember you have to have time too. Otherwise calendar views can act funky.
I used following formula:
@TextToTime( @Text(DateList) + " 12:00 PM" )
I also set start date column to datetime type and checked time display option in column property window. Problem still exists.