The date-time tag has no wiki summary.
9
votes
2answers
7k views
Safest way to get a date from Sharepoint into a C# datetime field, using object model?
If I have a Sharepoint list item with a date field.
How can I get the field value populated into a c# datetime object?
For example:
DateTime validfrom = Convert.ToDateTime(item["validfrom"]);
...
7
votes
4answers
740 views
CAML Now Instead of Today - CAML Bug?
I have a CAML query, in which the <Where> node looks like:
<Where>
<Leq>
<FieldRef Name='PublishedDate'/>
<Value Type='DateTime'>
<Today/>
...
5
votes
3answers
2k views
Caml to get today's birthdays
I have a list with birthday field (DateTime).
How do I write caml query to retrieve only the records where birthday falls on today (i.e. only comparing day and month value of birthday column to ...
5
votes
2answers
750 views
Why is central admin time different from server time?
I have seen this question asked before (not here) but have never seen anyone with a genuine answer, usually people provide lots of info surrounding how Sharepoint has a different timezome for each ...
4
votes
4answers
4k views
CAML query not working
I have written following CAML query to Retrieve items which are due in 7 days, It doesn't seems to be working, Please let me know what I missed ?
string internalEndDate = web.Lists["List ...
4
votes
2answers
533 views
DateTime list column with 1 minute increments
How can I change the time portion of a date time column to have 1 minute increments? When you create a coulmn by default it shows 5 minute increments, but I need to be able to use 1 minute increments. ...
3
votes
4answers
3k views
DateTimeField and timezone conversion problem
It seems that the datetime value which is entered into a DateTimeField is always stored as UTC no matter what timezone is configured for the current user.
Only the output on the page is displayed in ...
3
votes
2answers
2k views
How to set the Default value of a Date/Time column to next Friday?
I did some poking around in the documentation for Calculated field formulas, but I don't see anything that would help me do this. Does anyone know if it can be done? Can you point me in the right ...
3
votes
1answer
291 views
Set a date/lookup in ListInstance elements.xml
I have two lists. The first one has customers and the second one has Orders. Now i want to add some (test) data in the elements.xml of the listinstances. For customers this works without a problem
...
3
votes
4answers
782 views
Get SharePoint Server datetime
I was working on a functionality where we had to fetch list items from server using ECMA script (SharePoint 2010 Client Object Model) based on current datetime. The problem is that the datetime we ...
3
votes
1answer
180 views
“Changed On/Modified” columns - Date Format & Regional Settings
I was wondering if I change my regional settings through: Site Settings - Regional Settings - Locale: Dutch (Netherlands), affects the date format of the standard columns (Changed On/Modified e.g.).
...
2
votes
1answer
187 views
Why is default ScheduledItem StartDate a 'weird' value?
If you create a new ScheduledItem object and look at the StartDate - it's 1/1/1990 - why? This has just caught me out when trying to evaluate whether the dates have been set or whether they're, what I ...
2
votes
2answers
2k views
Assigning Today() on a DateOnlyType field on InfoPath 2010
I made an InfoPath 2010 form using a SharePoint list template. The SharePoint list has a ReceivedDate field of DateOnlyType which I would like to set using the today() or now() on a "Set a field's" ...
2
votes
2answers
1k views
Possible to use DateOnly with the DateTimeField control?
I have a DateTimeField control that I would like to only display dates with. I tried setting the DateOnly member to true but when I try to save the page that is using this it throws the following ...
2
votes
2answers
1k views
How do I format the Custom Field DateTime?
I want to create a date input box. When you select a date, it puts it in the format dd/mm/yyyy using the following Custom Field.
<Field ID="{3a521b04-fca1-4707-9134-fa4acd1456d8}" ...
2
votes
3answers
344 views
Issue with Sharepoint DateTimeControl
DateTimeControl is inside grid and i bind grid inside !ispostback section, on row databound of grid i find that datetimecontrol and disabled it.
when button click(outside of grid) DateTimeControl ...
2
votes
1answer
195 views
FormField value set with javascript, value lost on postback
I have a custom list of "requests" which need to accommodate a required time range for a single date (among other fields), so I added "start" and "end" columns of date and time type. I used designer ...
2
votes
1answer
358 views
Making DateTime fields ignore user timezones
We have a number of forms using a standard DFWP to serve up some simple forms. A few of these forms have datetime fields only showing the date portion. We're experiencing some issues where user A in ...
2
votes
1answer
625 views
Incorrect Modified Dates on SharePoint Online for clients in other timezones
I've run into a strange problem with SharePoint Online.
When updating or creating entries in a list using the Client Object Model, the modified date on the affected list item seems to be stored with ...
2
votes
0answers
299 views
Should SharePoint Alerts automatically adjust for Daylight Savings Time changes?
We have a SP2010 farm that is up to the October CU. After the time change, some users report that alerts that were sending out at 10am are now being sent at 9am. I've googled a fair amount and found ...
1
vote
2answers
2k views
setting current date time in sharepoint form field (newform.aspx) sharepoint 2010
I am working on customizing the sharepoint list form (newform.aspx). So soon as the user opens the new form I want the Odate coloumn (date and time) to be filled automatically with the current date ...
1
vote
3answers
2k views
CAML Query Filtering with OffsetDays
I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this:
If a date is not specified on the Query String, then show me items
created in the last 30 days
If a date is ...
1
vote
1answer
93 views
Date column showing as “Date and Time” even though “Date Only” selected
In a workflow I have set up on a list, the email that is generated is showing a date with both date and time, with the time at 12:00:00 AM (using a lookup of one of the list's columns). Checking the ...
1
vote
2answers
316 views
Display and Sort on Date and Time Managed Property
I'm using a CoreResultsWebPart to display the latest articles in a short list. To display the last modified Date and Time I've created a Managed Property called LastModifiedDateTime (I'm aware of the ...
1
vote
1answer
931 views
JavaScript SP.CamlQuery() return DateTime fields with offset (in my case +11 hours)
JavaScript SP.CamlQuery() return DateTime fields with offset (in my case +11 hours).
In standart Display/Edit forms and views display correct DateTime.
How to get correct DateTime via SP.CamlQuery()?
...
1
vote
1answer
1k views
Date & Time column display strange value in disp form
I have created a date & time type of column in my custom list, I have selected date only as display format. I can just fill date in this field on new item form but when i see this field in display ...
1
vote
1answer
2k views
Add a last modified date column for each row in Sharepoint 2010 list
I have a list where I have some columns, my requirement is that I need to add a column, which will update the last modified date for each row.
That is if I edit one row today, add today's date to ...
1
vote
3answers
42 views
Calculate the difference between system columns Created on and Modified on
I'm trying to create a new column in a shp list that contains the difference in days between two other columns in that list. These two columns are the custom list columns that contain the date Created ...
1
vote
2answers
242 views
CAML OffsetDays
please help if it possible that CAML OffsetDays is not working in DvWP?
I use the following CAML within a DVWP:
<View><Query>
<Where><And>
<Lt>
<FieldRef ...
1
vote
2answers
143 views
BCS Date Only field on Update Form
I'm tasked with finding a method for Updating a field that is defined as Date in SQL, but rendered as DateTime through BCS (as there is no Date-only type). On the Update form, I only want a Date ...
1
vote
1answer
789 views
How to set empty value to DateTimeField WebControl?
We tried to use DateTime.MaxValue to set empty value for DateTimeField and it works quite nice on our test environment, but we get following exception on some production farms.
Exception: Ticks ...
1
vote
2answers
795 views
How to set date field to Today's Date in Wss 3.0 Custom list form programatically
How can i pre-populate newitem.aspx form with today's date. When user adds new item i want to prepopulate date field with todays date.
<SharePoint:DateTimeControl ID="dtcDateofInsp" ...
1
vote
1answer
253 views
sharepoint designer - collect data from task - date and time
I'm using sharePoint designer 2010,
I have creted workflow.
I used the task "Collect Data From User", and I defined field as "date and time" type.
the user filling the task field and I can see the ...
1
vote
2answers
530 views
MOSS 2007 - Filter calendar to display currently running event
I want to create a view for a calendar. The view must display only currently running events.
Right now, I can create a view that filter on for daily event : I currently filter events with Start Date ...
1
vote
2answers
143 views
Calculating event lengths that cross time changes
I have a calculated field to work out the length of an event in days, as follows:
=DATEDIF([Start Time],[End Time],"d")
I live in the UK and we're currently on BST; so if I create an event in GMT ...
1
vote
1answer
134 views
sharepoint date column calculation
This is my first day using SharePoint and I was lost in trying to figure out how or if it can be done, custom column calculations, and if code is allowed in SharePoint? I am using SharePoint 2010. I ...
1
vote
0answers
93 views
How to make report in SharePoint 2013?
I am trying to make Report of Time registration part in SharePoint 2013. And I try to use Access View but SP 2013 doesn't have Access view or I didn't find out it. If you have any advice or suggestion ...
1
vote
0answers
37 views
Combine 2 seperate date and time columns into one
I have 2 separate columns in a list document library one is date and one is time can they be combined with a calculated column? If so how?
Thanks
Lewis
1
vote
0answers
88 views
SOAP returns DateTime with timezone offset added to minutes
I am using the Ruby gem 'viewpoint/spws' (from a RHEL 6 server) to insert items into a Sharepoint list via SOAP.
It seems that the DateTime fields being passed are being incorrectly interpreted by ...
1
vote
0answers
52 views
Wierd format of Modified date and PublishingStart
Iam having trouble with date formats of these two fields: Modified and PublishingStartDate. They are different in format. Iam attaching how they display on my computer. I have regional settings set to ...
1
vote
2answers
201 views
CAML Query List by months
I was wondering if i have 3 random dates.
11/12/2012
9/24/2011
12/29/2008,
I'd like to have
September
9/24/2011
November
11/12/2012
December
12/29/2008
instead of using the query to sort by ...
1
vote
1answer
141 views
SP 2010 REST $filter column
I'm trying to filter a list using the REST service. The column im trying to filter is the default column "Modified". My problem is: I can get all itens created today, but not only the items created ...
1
vote
1answer
529 views
How to convert date field in single line of text using Calculated columns
I have created a calculated field for a content type in my Sharepoint 2010 and I want to return a date in the TEXT format because I am returning some text with it. The condition I have put in the ...
1
vote
1answer
460 views
Validation of dates in different fields in sharepoint
My question is on validation of dates in SharePoint…
If i have two date fields – start date(& time) and end date(&time). How do i validate these, so that a person cannot pick a time in ...
1
vote
0answers
172 views
Week number formula for date and time column
What calculated field formula would show me the week number for a date and time like this:
5/27/2012 6:00 AM
All the formulas I found are only for dates.
1
vote
2answers
702 views
Filter an External List on a datetime Field
So I have an external list in SharePoint 2010 that connects to a SQL database and pulls the data successfully. I also have 2 filters defined along with a limiting (TOP) filter. The first filter is ...
1
vote
2answers
609 views
SharePoint Designer: CurrentDate CAMLVariable is incorrect to compare to date column
I am creating a simple form by "Insert Data View" web part and filtering on the data source by date.
Something like: Displays all the announcement items that have:
"Expires" Greater Than Or Equal ...
0
votes
2answers
122 views
Saving date on sharepoint profile
I have a method on my code that stores the birthday of users on a Sharepoint profile property (BirthDay).
This property only accepts the format "yyyyMMddHHmmss.0Z" so i have the following code:
...
0
votes
3answers
3k views
SPServices <today /> not returning correct results
This is the chunch of code that I am working with. I am trying to get only the events (normal/all day/recurring) to show, and it is returning all items for the whole week. Any ideas?
...
0
votes
1answer
369 views
Converting datetime column value to server datetime value
I am trying to build a calendar with date time columns. My SP 2007 server is in US and I am trying to use this site in India. My server returns the EventDate column value in India format. I want to ...
