.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Use Sharepoint Calendar Start Time field in calculated column

Posted By:      Posted Date: August 30, 2010    Points: 0   Category :SharePoint
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])) SerialNumber2=DATE(YEAR([testdate]),MONTH([testdate]),DAY([testdate])) Start Time  SerialNumber1 Testdate  SerialNumber2 8/31/2010 40420 8/31/2010 40421 8/31/2010* 40405    9/1/2010* 40405    9/2/2010* 40405    9/7/2010 40427 9/7/2010 40428 9/13/2010* 40405    9/14/2010 40434 9/14/2010 40435 9/14/2010* 40405    9/15/2010* 40405    *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

More Related Resource Links

Trying to set Calendar Time Interval Using Calculated Column, but getting Error



So i was trying to use a calculated column that added 7 days to the start date of a calendar item. The calculated column worked fine because i checked with several tests. Then i tried using the Column as the End Time in the Time Interval Setting in the Calendar View. This broke Sharepoint. Not the normal graceful error im using to seeing from Sharepoint but the Server Error Page when a dump happens in a ASP page. I havent enabled the full error page because i assume its not like i can fix it, i dont have the source code.


Does anyone else experience this? If so is it a known problem and being worked on?




How to Hide Start Time and End Time for All Day Event in Sharepoint Calendar DispForm

Hi All, Currently, when I add my Calendar web part to my page it displays the date and time for start and end dates. How can I get my web part to hide the times and only show the start and end date when the All Day event box is checked?

reserving time on sharepoint 2007 calendar

HI all,
 I need to have a sharepoint calendar where if I reserve a time that is being used from 12pm-2pm, another person/ same person can't come in and reserve the same time from 1pm-2pm  or 12pm -2pm for the same day. Is there an easy way to do this?

How to read a column of a sharepoint list to a text string field of infopath form?

My infopath form used to read these email addresses from a web service and web.config file. Now i would like to get these user email addresses from a contact list in a sharepoint server. I am trying to do this without writing any codes. Here is what i have done so far: 1. Adding a new "data connection to receive data from SharePoint library or List" where i selected Email Address column of the contact list. 2. I added a new Text Field and define a new rule with "Query using a data connection" defined above. When i try to access the newly created Text field above it always return empty as if the Query attached to it did not executed at all. What did i do wrong? Is there a better way? Thank you in advance for your help.

Filter items with a date column with parameters start date and end date on a sharepoint list?

If I have alist with a view that has the columns Title, Status and Status Date and the view has some items. How Can I add a filter with two parameters, start date and end date, to only show records with status date equal to or greater than parameter start date and status date is less than or equal to parameter end date? This is a sharepoint online site and I can't create and deploy custom code, can use SPD though. Do I need to use SPD or is this something I can do in the list settings? Thanks in advance.   Edit: I had a look here http://www.endusersharepoint.com/2009/09/29/sharepoint-date-filter-filtering-a-list-by-greater-than-or-equal-to-date/ but I don't have the Date Filter web part.

Sharepoint: In Calculated Column, Code with multiple "IF" condition does not work.

Implemantation:  Calculate expected resolve date exclude "Saturday" and "Sunday"  based on Priority and Severity.Columns are:1. Priority:2. Severity:3. Raised on: Date record createdCode: Below is the code which contains multiple "If" conditions. For quick undersatnding, i separated major If condition. Below code does not work and sharepoint gives me Sytax error message. =IF(OR(Priority="Critical",Severity="Critical"),IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+3,[Raised on]+1),     IF(OR(Priority="HIGH",Severity="HIGH"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+4, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+4,[Raised on]+2)) ,   IF(OR(Priority="MEDIUM",Severity="MEDIUM"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+5, IF(TEXT(WEEKDAY([Raised on]+3),"dddd")="Saturday",[Raised on]+5,[Raised on]+3)) ) ,   IF(OR(Priority="LOW",Severity="LOW"), IF(TEXT(WEEKDAY([Raised on]+1),"dddd")="Saturday",[Raised on]+6, IF(TEXT(WEEKDAY([Raised on]+2),"dddd")="Saturday",[Raised on]+6, IF(TEXT

SharePoint 2007 to Access 2007 - Issues grouping by "Person or Group" field type/column

We are on SharePoint 2007 and using Access 2007.  The SharePoint list contains a column called Assigned Person, column type: Person or Group, single selection, displaying only the name 1) When we Open with Access and Export a copy of the data, then create a report from that table, we do not have the option to group on Assigned Person.  2) When we Open with Access and Link to data on the SharePoint site, then create a report from that list, when we group by Assigned Person... The same person has 2 groups - there are is no other grouping or sorts on the list, and i can't locate a correlation to another field to show why they would have to collections for the same person The Person or Group column sorts "from smallest to largest" as though it is a number field. The list is a task/activity tracking system we created custom for our needs.  We want to pull a weekly report, grouped by Assigned Person, but cannot get access to work.  We do not want to resort to anything more complex, as it takes a much longer process to have reports pulled by Chrystal or one of those types of applications.  And we cannot change out the field for something like a Choice column as the list already has a very large amount of content.  Can anyone assist? Is there a setting hiding somewhere that is causing the problem? 

Sharepoint Calendar export to Outlook but can only view the Title column

I have created a Calendar in Sharepoint for booking out company vehicles. The fields I have created are: Vehicle (Choice), Driver (User/Group), Start & End Times, Title (text), DisplayField (Calculated text based on Vehicle + Title...... it would be nice to include Driver but it seems Sharepoint cannot handle the User/Group datatype in a calculated field.....but I digress). I use the DisplayField calculated field in my default calendar view in Sharepoint. All is good at this point. When one connects it to Outlook (via the Action menu in Sharepoint) the calendar is added but all the entries show only the Title field. If I double click on an entry, only the title field appears - the Vehicle and Driver values are missing. When I try to create a new entry - only the Title field (plus other default Outlook fields) are available. So: How can one display a value other than Title by default, and how can I display the other columns when looking at the event detail?

Weird Date vs Date/Time issue using a calculated column

I'm attempting to use the fab 40 attendance template. I don't need the time to show - Im able to hide that on the forms with jquery (endusersharepoint.com thank you!!) I WAS ATTEMPTING to create a calculated column called Start Date where the formula simply reads '=[Start Time]' When it's set to display 'Date Only' the date is off by a day. If I switch it to 'Date & Time' I get the correct date. Huh?

Calculated column and hyperlink field type

Hi I have customer who is asking me if this is possible to provide filter based on the HyperLink field, where he could easly limit results to only those items where link field is filled. As filtering on hyperlink column type is not supported I was thinking to buld some calculated field based on it to return YES (if link is provided) or NO (if link is not provided). The problem is that hyperlink field type is not avialiable on the list of field to be used on calculated field. is there some workaround for that ? thanks for help   Mariusz Gorzoch Blog : http://mariusz.gorzoch.pl Twitter : http://twitter.com/MariuszGorzoch Facebook: http://www.facebook.com/mariusz.gorzoch

Map an InfoPath form field to a SharePoint column

I am trying to create a custom SharePoint list template feature (feature.xml, schema.xml, the whole nine yards), which is based on the OOTB XML Form Library in MOSS 2007. I copied the XmlFormLibrary feature out of the FEATURES folder on my SharePoint server, and made a few minor modifications (changed the feature name, new GUID, added some fields in schema.xml, created a new content type for it, etc...).

What I ultimately want to do is publish an InfoPath form template into it as the document template for the library, and I would like to be able to map certain fields in the form template to fields in my custom SharePoint library template. In InfoPath, I open the Publishing Wizard and go through the typical steps to publish to a Document Library. I then choose the columns in my form that I want to promote to fields in the form library, and select the appopriate fields to map to in the form library. I publish the form, and do not get any errors or warnings.

However, when I choose "New" from the form library and fill out the form and save it, only certain fields in the library are actually being populated from the form. Specifically, this seems to work fine for a date/time field I am using, but does not work for the "Location" field. I am using the OOTB "Location" field from the "Core Contact and Calendar Columns" group. Ev

Calculated Column: Text ==> Date and Time Column (Date+Time)





I have a little question about calculated columns in WSS 3.0 (not MOSS 2007)


How can I have a calculated column which is a Date+Time based on a text_column

Converting YYYYMMDD_HHMM (time = 24 hour format) format  ==> Date+Time



20070629_0848 converting to 29/06/2007 08:48


==> I have already a formule, but with teh DATE(...) function, you cannot give the hour-minute-seconds as a parameter, so the time is always 00:00 in WSS 3.0 (and yes, i have selected date+time as result-type for the column)


Is this possible in WSS to calculate a full date out of a text, maybe if i use two seperate text-columns, and convert a to date and one to time and a third which combines the two...


It would be a huge help if somebody could give me som advice to calculate a full date+time out of one or more text-columns....





Attendance column not showing up as field when creating new calendar item

I have a SharePoint calendar, with a little over a dozen columns (I have also added a couple extra columns). When adding/editing calendar events, I notice that the Attendance column is not showing up as a field. If I look in SP Designer, I see the column, Attendance, but it shows a blank Content Type (whereas most all the other columns have a Content Type of Event). Can someone please talk me through this? Not only do I need the Attendance column to be a field for a calendar event, but I have the same calendar on many other sites, so hopefully I can update the Content Type for the Attendance column to Event and solve my problem. Please advise.

Sharepoint image column field

My current project requires ability to display choice column value via color or image associated with a choice 

But Sharepoint standard packaged misses that control 

I am looking for available solutions on market 

I came across 

Does anybody has experiece using it?

Summing a calculated column with comma's in sharepoint designer



Sharepoint designer has the trait of getting goofed up with calculated columns that display with a comma.  I typically deal with this by doing a format-number(number(translate(@MyCalculatedColumn,',','')), ###$%%^formatstuff).  this replaces the comma's with nuthing so it will format as a number.

I'm trying to do a sum now...is this possible?


  <xsl:variable name="Rows" select="/dsQueryResponse/Rows/Row[contains(@FileRef,$TheIDweWant)]"/>
  <xsl:variable name="zNumMales" select="sum($Rows/@MaleLives)"/>
  <xsl:variable name="zTotalMaleVolume" select="sum($Rows/[number(translate(@MaleVolume,',',''))])"/>

The zNumMales works fine...it's just a number column populated by a workflow.

The zTotalMaleVolume is calculated, has commas so it displays as blank, we need to get rid of the comma's.  the above syntax is upchucked...anyone happen to know what it is?



Workflow SPD: Set Today Date+Time to Column-field




I have a little question about settings specific today (Date + Time) value to a field/column within a workflow that is designed by Sharepoint Designer 2007.


I can manage to set the field to today() => but the time is always 00:00 houres.

I would like to set a specific field to the "exact" date+time when the workflow is running. (so choosing a fixed date+fixed Time isn't a solution either)


So I anyone could help me how I can do such "simple" task, I would be very pleased.






Naming a SharePoint Column Differently Than the InfoPath Field Name



I have built a project intake form in InfoPath and am submitting it to SharePoint.  Part of the form uses the Person/Group Picker control.  I wish to publish that field to SharePoint upon form submission.  However, the column title is "Display Name."  Is there anyway I can change the name of that?  I tried editing the list in SharePoint and that field is not editable.  I also tried renaming the field in InfoPath, but it is part of the Person/Group Picker control, is a locked field, and will not let me change the InfoPath given name.  I also looked at changing the name of the field during the publishing wizard process, but it will not let me do so there either. 

Am I just stuck with that name if I want to use the Person/Group Picker control?

I am using InfoPath Designer 2010 and I believe SharePoint 2010 (although it may be MOSS 2007).


ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend