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

learn more… | top users | synonyms

2
votes
1answer
492 views

How to convert date based on current users, using client side code

I have a date that I want to display to the user, and the format should be dynamic and based on the user. If I do this I get a format that doesn't fit every user. var prettyDate = originalDate.format(...
2
votes
3answers
11k views

Check for empty date in SPD Workflow

Question How can I check for an empty date condition in a SharePoint Designer Workflow? Background I have a list called "Project" with multiple date fields. I have a calendar called "Project ...
2
votes
3answers
10k 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 ...
2
votes
1answer
145 views

Using NOT on REST date query

I am able to filter for items created on a specific date with the following query (using today [03-06-2015] as an example): "$filter=Created ge datetime'2015-03-06T05:00:00.000Z' and Created lt ...
2
votes
1answer
639 views

Access Uploaded Document's Original Creation Date in SP2010

I've spent some time searching this site and others but haven't seen a conclusive answer to this question: is there a non-code way to display the original creation date for an Office document in a ...
2
votes
1answer
3k 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 ...
2
votes
1answer
521 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
1answer
3k 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()? ...
2
votes
1answer
898 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 ...
2
votes
2answers
911 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 ...
2
votes
1answer
47 views

List formula date conditional not working

I have a list that takes an Open Date and adds 90 days to set a due date: =[Open Date]+90 However, many of the Open Dates are years old. I've been asked to change it so that dates created before ...
2
votes
1answer
35 views

Weekly Date Intervals

I am trying to get weekly start and end dates displayed automatically (as i am going to be pulling reports weekly, this will be helpful). For example, if today was monday 6/24 - would like to pull ...
2
votes
1answer
671 views

How would I take a date field and subtract 30 days to show the month prior to the original date

I have records that are modified each month. The site is used to display the previous month's information. However, to make sure that the information is correct, I want to use the date the ...
2
votes
2answers
145 views

Getting latest datetime from a splist

I have sharepoint list with data and one of the columns contains date ... how can i programmatically retrieve the latest date, the field is a Date And Time type?
2
votes
4answers
966 views

Issue with Sharepoint DateTimeControl

DateTimeControl is inside grid and I bind the grid inside !ispostback section, on row databound of grid I find that datetimecontrol and disable it. When button click event (outside of grid), the ...
2
votes
2answers
226 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 ...
2
votes
2answers
2k 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: System.Collections.Generic.IList`1[System.Xml.XPath....
2
votes
2answers
3k 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}" Name="...
2
votes
0answers
39 views

Display datepicker on top of the forms's modal dialog

I have a custom item edit form and I have a couple of DateTime properties that has to be filled at the bottom of the form (using datepicker): So when I click the mini calendar icon to choose the ...
2
votes
1answer
91 views

Format Date in Content Query

I have looked through too many threads about this and have made no progress. So far the following links have helped me the most: Content Query WebPart & Date How to format Date in Content ...
2
votes
0answers
53 views

CQWP XSLT ddwrt:Today() return PST time zone instead of Local time zone

I am working on CQWP webpart in Office 365(SharePoint Online). I have to get today's date for date comparison. I have use xmlns:ddwrt="http://schemas.microsoft.com/WebParts/v2/DataView/runtime" for ...
2
votes
0answers
79 views

The upcoming leap second and SharePoint

Is there any known issues when a leap second occurs? Leap years seems to be fine but i have yet to find any information related to leap seconds and how it could possibly have any impact on SharePoint. ...
2
votes
0answers
43 views

Different Times between View and DisplayForm in Calendar

The setup: I am using a default Calendar list in SharePoint 2010 Enterprise. The calendar is being used to track meetings in for a specific meeting room. The calendar has content approval required ...
2
votes
1answer
763 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
2k 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
525 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 ...
2
votes
2answers
1k 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 ...
2
votes
1answer
779 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
4answers
8k views

REST service $filter Date column

Using the REST services, I'm trying to filter by the Created column, which is a Date data type. When trying to $filter on that column, I passed in the same date format that comes back in the JSON ...
1
vote
2answers
3k views

REST API filter by month

I would like to filter a datetime field but I only want to filter MONTH var requestUri = "xxxx/getByTitle('Contact')/items?$select=CellPhone,mdate,ddate&$filter= Birthday ge '" + today + "'"; ...
1
vote
1answer
2k views

sharepoint designer - get current server datetime through javascript REST

Is it possible to get current date time of sharepoint teamsite hosted server through javascript REST api?
1
vote
2answers
7k views

On Sharepoint 2013 how do you show the last modified date on a page layout

Currently have a page layout were I would like to be able to display the last modified date of an article. However I can't see how this can be done as there's no snippet in the snippet gallery were ...
1
vote
4answers
101 views

workflow 2010 will show a Date equal to 01/01/0001 inside the email, if the Date is empty

I am working on SharePoint server 2013, and i create a new Workflow 2010 inside Sharepoint designer 2013. now inside the Workflow i set an email which contain the following value:- [%Current Item:...
1
vote
2answers
137 views

Calculated Column with time element

I know I've read that dates and time don't do well in lists. Does anyone know a workaround to create a calculated column that will bump the number up in the column by 1 every 24 hours. So the column ...
1
vote
3answers
455 views

In a Page. How to add a flag that inform last time a list was modified

I have a custom page like this : These are my links (refresh once a day. Last refresh time : **XXXXX** ) link1 link2 link3 And I have a custom list. I want to add "last modified time" or "...
1
vote
1answer
1k views

How to default a date field to a particular day of the week?

When a new list item is added, I'd like a date field (Date From) to be defaulted to Monday of this week, as well as another date field (Date To) to Sunday of next week (creating a 1 week span Mon-Sun)....
1
vote
1answer
4k views

How to format Date in Content Query Web Part?

I have a CQWP in which I am querying the data from a document library. ItemStyle being used is "Title and Description" Title displays the title of the Document and the in Description I have given a ...
1
vote
2answers
6k 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
2answers
21 views

Calculated field for difference between two times

I have a list with a "Start" field and "End" field. I'm using a calculated field to determine the difference in hours and minutes between the two. Start - 9:00 am End - 10:30 am =TEXT(End-Start,"h:mm")...
1
vote
1answer
668 views

Converting date from utc to regional setting (cultural info) of the site

I have a question, basically i have a date time which is by default in UTC, how do i programmatically convert it to a correct date time in regional settings of the site collection / or user?
1
vote
1answer
1k views

SharePoint 2010 REST Date/Time format

In SharePoint 2010 REST API when I call to _vti_bin/ListData.svc/Documents(38)/Created and get JSON response the date/time is returned as /Date(1421146908000)/ (I found some information about it but ...
1
vote
1answer
142 views

Filename Date Format SharePoint 2013

I am trying to change the filename date format for an InfoPath form generated item. Currently I am using this file name formula: concat("Backup", "-", today()) Which results in this filename Backup-...
1
vote
1answer
300 views

What is SP.dateTimeUtil.js?

I found SP.dateTimeUtil.js contains all date and calendar formats and modified one of them to customize display of dates but SP 2010 doesn't use this file anywhere. I need customized Calendar.aspx and ...
1
vote
1answer
5k 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
3answers
167 views

How can I convert the format ctx.CurrentItem.Created

I am using SP2013 on-premise. I have applied client side rendering to convert the Item created datetime to specific format. The problem is "ctx.CurrentItem.Created" always return a string format as ...
1
vote
1answer
325 views

SP.TimeZone.utcToLocalTime how to use

I'm trying to use SP.TimeZone.utcToLocalTime via REST API, but can't understand which format is right for input (with Date and Time). It works only with date /_api/web/RegionalSettings/TimeZone/...
1
vote
1answer
241 views

Seconds since item created with REST. Perhaps use server current time (clock)

I'm trying to find the most correct way to determine the amount of seconds since an item was created. My first approach is to simply diff the Created property with the browser time, e.g., moment()....
1
vote
2answers
132 views

How to trim down date to example 2014-10-10?

How can i trim down date from this Fri Oct 31 2014 01:00:00 GMT+0100 (Västeuropa, normaltid) to this 2014-10-31 on my get_fieldValues i think i can use .setDate.getDate()+ 1).toISOString().substr(0, ...
1
vote
2answers
290 views

Find Interval Between Dates Problem

I have a very odd problem, one that's been baffling me for over a week now. I have a workflow designed to create a new task a set period of time in the future once a current task expires. These tasks ...
1
vote
2answers
151 views

Create SPList Metadata

I want to give a SPLists a Expiry Date so they are later deleted through a timerjob. The value is set by the user when they create a list through my functioning visual webpart. Is it possible to give ...