I'm trying to limit the calendar view to current week using the Sharepoint defined field Start Time. However, when I display the serial number behind the Start Time it looks like it is actually giving me the serial number for the Created Date field.
I believe it is because the appointment is reoccurring but I'm hoping there is a way around it. I created a new testdate field and manually entered the date and set those appointments as all day events however they are not reocurring appointments. The testdate
returns the correct serial number however the start time returns an incorrect serial number.
SerialNumber1=DATE(YEAR([Start Time]),MONTH([Start Time]),DAY([Start Time]))
Start Time SerialNumber1 Testdate SerialNumber2
8/31/2010 40420 8/31/2010 40421
9/7/2010 40427 9/7/2010 40428
9/14/2010 40434 9/14/2010 40435
*These are reoccurring appointments scheduled as all day events. The others were entered as one time appointments scheduled as all day events.
View Complete Post