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

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

list date value

Posted By:      Posted Date: September 03, 2010    Points: 0   Category :SharePoint
In share point few list date value are showing correctly, but same value are display from sql server diffently. Eg. List date valu : 25-july,2010 SQL server : 24-july,2010 why its happened for few list.

View Complete Post

More Related Resource Links

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.

Updating a List item field value in a SPD Workflow is setting Date fields to null

Hello everybody,I faced a very weird behavior while creating a workflow in SPD against a Document Library.Here is the case:1- Create a document library in sharepoint site.2- Add a custom column of type DATE.3- Upload any document to the library4- Edit the item metadata and set the custom date field to any date you want.5- Now using sharepoint designer, create a very simple Workflow with only one action that updates the current item "Title" field to any value. (Note: In my case I set the workflow to start manually and not automatically)6- Save the workflow and then start it on the uploaded item.7- Now check the value of the date column after the workflow is finished.8- You will see that the Date field is Empty... (very weird)Notes:   1-This behavior will not appear on a standard list. it is only appearing in a Document library.  2- I am using WSS 3.0 SP2 + MOSS 2007 SP2. Also SharePoint designer 2007 SP2Did anyone face this situation and does it have a fix, or am I doing something wrong here... Please help.Regards,Maheed

Calculated date field displays differently in List View and Data View web parts

In SharePoint GUI I created a simple custom list with a calculated Date/Time field (Due).  The calculation is =[Created]+7.  I'm trying to display this data on a page using a DVWP.  But first, for testing purposes, I also created a second calculated Date/Time (TestCreate) field in my custom list that is simply =[Created]. In the List View from within SharePoint, the dates show as expected (for example): Created = 8/12/2010 3:45 PM Due = 8/19/2010 3:45 PM TestCreate = 8/12/2010 3:45 PM In SharePoint Designer, I added a Data View web part and the above three data elements (each configured to display mm/dd/yyyy hh:mm:ss tt).  I see the time displayed for the example list item as: Created = 8/12/2010 3:45:30 PM Due = 8/19/2010 10:45:00 AM TestCreate = 8/12/2010 10:45:00 AM I've tested a couple scenarios and the calculated fields always display five hours in the past (along with dropping the seconds).  It seems like the DVWP is returning the date in a different time zone (with no seconds).  The lcid is set right (1033).  I didn't see any time zone settings for the DVWP specifically.  I'm basically stuck.  Could someone help me figure this one out. Thanks.

Dynamic list item title based on date created & regional settings?

I have a list of things that doesn't *need* a title.  However, because sharepoint uses Title for links, RSS etc  I tried generating a title in an event handler.   This would work great if I wasn't basing it on a date field: public override void ItemAdding(SPItemEventProperties properties) { DateTime dt = Convert.ToDateTime(properties.AfterProperties["TestDate"]); properties.AfterProperties["Title"] = dt.ToShortDateString(); base.ItemAdding(properties); } In testing, this sets the title to "8/9/2010" when I selected 8/10/2010 in the date picker.  I figure this is because of the regional settings of my test user.  I can probably correct the title value for 'test user' but that won't fix 'test user in mongolia' who would still see two different values. So What I would like is to have the Title always display the value MyDate in the uesr's locale.  So the field needs to be dynamic not only at edit/update time, but at display time. Does anybody know if this can be accomplished, and more specifically how?

Rich Text in list forms & date picker

Hi, I was hoping that someone could help me on a few issues. I have created a custom list form in sharepoint designer to display the contents of my list in a nice format. I have also customised the edit form for the list. I am having a problem with special characters now showing up when they are being entered (the HTML does not seem to be parsed on the output). I would like to make a description field in my list edit form a rich text box, is this possible? This is the code I am using at the moment for the text box: <asp:TextBox runat="server" id="ff5{$Pos}" text="{@status}" textmode="multiline" __designer:bind="{ddwrt:DataBind('u',concat('ff5',$Pos),'Text','TextChanged','ID',ddwrt:EscapeDelims(string(@ID)),'@status')}" Width="600px" Height="100px" /> And this is the code that I am using on the display side of the list to show the status update: <xsl:value-of disable-output-escaping="yes" select="ddwrt:AutoNewLine(string(@status))" /> Is there code that I can use on the data entry side that will show a rich text box? Also then I will need to change the tag on the display end so it parses the HTML? In addition to this, is there specific code for a 'date picker' ? At the moment my date entry box is just a standard text box, is there code I can u

How do you filter a list in a Meeting workspace based on the meeting date?

I have a customer who is using a meeting workspace, and has a list on said workspace (we'll call it "Meeting Instance List"). The workspace houses this list, and of course after each meeting, the workspace, in essence, resets itself in preparation for the next meeting - so it looks like it removes the items from the list, when in actuality, they are there, just on the previous meeting instances. Some of his stakeholders are finding this limiting because they perceive it as losing historical information (you know how some folks can be, if they don't see it, they think it's gone). His solution is to replace the non-series list, with a series list, and incorporate legacy records from another older list. Only problem is, now there's not a way to filter the series list so that it shows items from a parcticular meeting date. For instance - the [Today] variable will only return a current system date value. Surely there ought to be a similar variable that would all you to filter the list based on meeting date, right?

update list text or date value via sharepoint designer using JAVA


Hi All,

Bit of a noob question - but tried all sorts and can't get this to work - also first time i've ever used sharepoint.

(I'm using sharepoint designer 2007) I have a form, on the form i select a type (drop box choice) and it hides or displays a related field, I want to auto populate the field when it displays, below is the java i have currently. 

Please advise how to populate (date field) with tommorows date, and also if it was a text field with the word "testdre"

<script type="text/javascript">
  function hideFieldsOnStart()
   //hide the control at start
   var control = getTagFromIdentifierAndTitle("input","TextField","Urgent Change Justifacation");
   //add an onchange event to the dropdown
   getTagFromIdentifierAndTitle("select","DropDownChoice","Change Type").onchange = function() {ChangeEvent()};
  function ChangeEvent()
   //get the dropdown



  SaleDATE        AMOUNT
  2000/06/04         10
  2003/12/08         20

        ,AMOUNT INT
        INSERT INTO @TMP VALUES('2000/06/04',10)
        INSERT INTO @TMP VALUES('2003/12/08',20)
 WHERE SALEDATE >= '2000/06/01' AND SALEDATE <='2003/12/31'

 24        2000/06/04 ~ 2000/06/10
 50        2000/12/03 ~ 2000/12/09

List ALL Dates in Date Range When Selecting Count


Say I have a table called "Visits", and I want to create a query that counts the visits per day. 

The way I would accomplish this would be to create a query as such:

SELECT Count(VisitId) as VisitCount, Convert(varchar(32), VisitDateTime, 101) as VisitDate
FROM Visits
WHERE VisitDateTime BETWEEN '10/1/2010' AND '10/5/2010'
GROUP BY VisitDate

The problem I am trying to overcome is that if there were no visits in a given day, that day does not show in my list.  For example, if there were 3 visits on the 1st, 2 on the 2nd, none on the 3rd, and 5 on the 4th, my result set would look like:

3, 10/1/2010
2, 10/2/2010
4, 10/4/2010

How can I create my query so that I get all days in the date range listed in the result set regardless of whether the VisitCount is zero?


How to be emailed about Scheduled end date on a document list item

I have configured a sharepoint document library to allow users to use scheduling and so it can be published and un-published on a given date. I need users to be able to set an alert to be informed about when scheduled end dates are reached. I tried using the out of the box alerts but this does not seem to be triggered. Can anyone suggest the best approach?

Need help with filtering a list based on Date and Time




We are implementing a SharePoint list for our resources to provide information as to whether they will be in the office that day, working from home, etc..


All entries are supposed to be in by 8:30 am and a report is created at that time; however, there are always a few stragglers. 


I would like to create a

"Date&Time" column in list - set actual time and sharepoint's proposes wrong hour (eg. 17:00 instea


I created new column in list - Date and time (Date and time format: Date&Time, Default value: Today's Date)

The problem is, when I create new item in list, the default time is always set as next full hour, eg. now it's 13:15 or 13:31 ora 13:57 and in aspx form it's all the time 14:00. Obviously, I can change that date with 5 minut precision (13:05, 13:10, 13:15 etc.), but it's kind of annoying.

Error When am copying Date column from one list to another List using Sharepoint event handlers


when am copying a date column from list A to List B.

am able to copy the the date but, copied date has date decreased by a day!



List A


Date= 11\26\2010


after coping to

List B


Date = 11\25\2010


any thoughts?

 DateTime dt;
            if (properties.AfterProperties["follow_x0020_Date"] != null)

                item["Status follow up date"] = properties.AfterProperties["follow_x0020_Date"].ToString();
                flag = 1;
                dt = Convert.ToDateTime(properties.ListItem["follow_x0020_Date"]);

Date time field in list



I have created a list with data time field. In the date time field,by default in minutes dropdown we are having 0,5,10.... with 5 as interval.

But I need to enter data time field as 11/16/2010 12AM 03.

How to change the intervals in minutes dropdown.


Cannot delete list items made prior to a certain date


A few days ago one of our SharePoint designers approached me with a problem with a custom list. He could not delete a certain item from the list. After troubleshooting it for a while, we determined that any list item made prior to 10/31/2010 cannot be deleted. These list items can be edited without trouble. List items created after that date have no problem with deletion. Other custom lists do not exhibit this issue. Also, no configuration changes or updates were made to the server on that date. Our last round of updates happened earlier in the month of October.

I have so far tried rebooting the server and re-indexing the database (only because doing so in QuickBooks seems to fix a lot of issues).

This is SharePoint Server 2007 SP2 Standard on Windows Server 2003 R2 Enterprise with SQL Server 2008 Standard. Everything is in a 32-bit environment. We have ample freespace on all connected drives.

I am fairly new to troubleshooting SharePoint issues, so I'll be frank that I may need some hand holding. Could one of you please offer assistance?

Want to delete item from sharepoint list prior to date



 Please help me to delete  item from list in sharepoint 2010 at EndDate and it should be added to the another Backup list, without using Visual Studio 2010 and  Designer



SharePoint Date Time Control logic for saving and retriving in List


Hi Friends,

     I am Ali, I need to set the SharePoint Date Time Control in my webpart.


1. When i am adding student details in Admission Form, ( Fields like Name, Class, data of birth, Date of Joining ...)

2. at Date Of Joining : here,  SharePoint Date Time Control should show the default date as (Sys date). 

For this i am using this :  

" DateTimeControl1.SelectedDate =DateTime.Now; "

it is working fine.

and For Saving " Date "  in list item From SharePoint Date Time Control i am using this :

listitem1["Date Of Birth"] = DateTimeControl1.SelectedDate.ToShortDateString();


3. When the user retriving the date from particular list, here Date Time Control should show the date, as what date he (student) was added in the list.

for Retriving date from List to SharePoint Date Time Control i am using this as below: But it doe

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