Represents an instant in time, typically expressed as a date and time of day.

learn more… | top users | synonyms

0
votes
1answer
126 views

SearchCoreResult returns Regional Date Value

I got the following formate returned from "Write" in english: <write>09/12/2012</write> I parse that with the following line and return a german format: 12. Sep. <xsl:value-of ...
0
votes
1answer
159 views

Want my column display minutes and want it to sum in hours

I have an issue again... I create list from csvfile. I convert string with date into DateTime type like this: string[] formattedDates = { "dd.MM.yyyy HH:mm:ss", "mm:ss", "HH:mm:ss", "dd.MM.yyyy", ...
2
votes
1answer
267 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 ...
0
votes
2answers
240 views

SQQuery, Dates and Regional Settings

First, some setup: My Site is set to Eastern Time, and the server is located in Eastern Time. I'm trying to run a query against a list using the created date. I have tried using all variations I can ...
1
vote
2answers
177 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
1k 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
990 views

Using a date column in a sharepoint online web chart web part

I added a "web chart" web part to a sharepoint online page from the browser interface. Next, I decided to run the Data connection wizard to connect my chart to an excel services. In the step 3 of ...
0
votes
1answer
162 views

Capturing Multiple Time Zones in Sharepoint

I need to capture multiple time zones in our Sharepoint site. Ideally I would like to enter AEST and have the other files calculate/convert to the various other timezones. Is there a way I can do ...
1
vote
1answer
566 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
1answer
1k 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 ...
0
votes
1answer
206 views

When is 'Article Date' populated?

I'm looking at different date fields of a Page I can use and have noticed there's an Article Date column under Publishing Columns. At what point is this column populated?
1
vote
0answers
196 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.
7
votes
2answers
2k 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 ...
1
vote
1answer
2k 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 ...
2
votes
1answer
209 views

Problems adding Date & Time values to a comparison using IF in a calculated column

I'm trying to compare a date by using =if([Modified]<DATE(2012,2,8),"Outdated","Updated") and it works just fine, but I have a problem with trying to add time to the comparison. What I need is to ...
0
votes
0answers
2k views

Set Due Date using a Workflow for a date 2 days after the item was created

Running into trouble using Designer. I need my workflow to set the due date for 2 days in the future but it will only let me set today's date or a specific date as the value.
0
votes
1answer
683 views

Date and time column in Custom List form

I have created a Date and time type column in my custom list and have selected "Date Only" for Display format, but it is always displaying the options to select data as well as time on the form. ...
4
votes
3answers
4k 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 ...
1
vote
3answers
3k 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 ...
0
votes
1answer
455 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 ...
3
votes
1answer
462 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 ...
1
vote
2answers
1k views

ddwrt Schema Unavailable?

So: I'm trying to use the ddwrt:FormatDateTime function in an XSL transform, but I'm getting the following error: Exception details: Method: ...
1
vote
0answers
81 views

Why does Search only accept YMD date format when Search Language is en-ca (usually DMY date format)?

For some reason the server thinks that the date format for English (Canada) is YMD or yyyy/MM/DD, and the server will only correctly read queries with that format. However, the default short date ...
2
votes
1answer
1k 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
1answer
361 views

Set date field in newform to selected date on calendarview

I'm looking for a solution where I first select a date on the calendar-view, when I add a new item, the selected date should be filled in on a field in my newform.aspx. Is this possible out of the ...
0
votes
3answers
4k 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? ...
1
vote
1answer
691 views

Calendar DVWP to show only today with recurring and all day events

I got a interesting problem here. I developed a dashboard for one of our departments, they wanted a widget that shows only today's events. I have the DVWP in place, and filtering by a calculated ...
1
vote
2answers
909 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" ...
3
votes
4answers
1k 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
259 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.). ...
1
vote
2answers
3k 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 ...
2
votes
2answers
2k 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 ...
5
votes
3answers
3k 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 ...
4
votes
4answers
6k 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
870 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. ...
1
vote
2answers
847 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
854 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 ...
2
votes
0answers
433 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 ...
3
votes
1answer
369 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 ...
1
vote
1answer
4k 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 ...
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" ...
0
votes
1answer
377 views

Having problem inserting JQuery Date into List

The situation I am using the Time Picker Addon (http://trentrichardson.com/examples/timepicker/) to allow user to select a date in the format of YY-MM-DD HH:MM:SS. The date is insert into a ...
1
vote
1answer
291 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 ...
2
votes
2answers
2k 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}" ...
0
votes
1answer
248 views

Calculate Time Passed After Item Created Using Javascript (or other)

I have a list that tracks loaned equipment. I want a little icon that is a visual indication at how long the item has been on loan to help visually cue employees to follow-up. For example: 0-4 ...
0
votes
1answer
64 views

DateTime Column type for import

I am looking at this http://spfileupload.codeplex.com/ to import files/folders with metadata. but it seems that DateTime is not supported. What's your input on this?
1
vote
2answers
755 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
152 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 ...
11
votes
2answers
11k 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"]); ...
3
votes
4answers
4k 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 ...