The Stack Overflow podcast is back! Listen to an interview with our new CEO.

Questions tagged [date-time]

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

Filter by
Sorted by
Tagged with
2
votes
1answer
1k views

Can anyone color code a column with an if statement?

Here is what I am trying to do. I have a SharePoint 2010 list that I want to color code dates based on that it expires 364 days after the date entered. Example: If the date is older then 334 ...
31
votes
6answers
89k views

REST API filter by start and end dates using 'today'

I'm new to filtering dates with REST in SP but am trying to do something like below but am not sure how to get today's date in as a variable into the request. I don't think I'm too far off so any help ...
3
votes
2answers
10k 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 + "'"; ...
5
votes
4answers
20k 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 Name"]....
0
votes
1answer
195 views

Send email reminder for 'rolling tasks'

I have used this question and Vedran's answer to have reminder emails being sent out based on a Date field. It has worked really well and has meant I can avoid using the unreliable 'pause until' ...
6
votes
5answers
25k 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 ...
1
vote
1answer
863 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
14k 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 ...
4
votes
4answers
22k 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 ...
2
votes
1answer
78 views

Range of Dates that start in 2017 and end in 2018

I am trying to use Flows to get a range of Dates as Integers that start in 2017 and end in 2018 I get my Data from the Get Events (V2) Connector and getting the Start Time and End Time to get the ...
1
vote
2answers
538 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 ...
17
votes
2answers
34k 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"]); ...
17
votes
4answers
15k 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/> </...
3
votes
4answers
5k views

SharePoint Designer - How to get current server datetime through JavaScript REST?

Is it possible to get current date time of SharePoint Team Site hosted server through JavaScript REST API?
10
votes
3answers
12k views

How to get the current time in a SharePoint 2013 workflow?

I have two SP2013 workflows that I built in SP Designer. They both do pretty much the same thing, but for different fields. In both of them I set a DateTime workflow variable to Today. One of them ...
8
votes
5answers
29k 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 ...
5
votes
4answers
16k 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 ...
4
votes
3answers
6k views

SP2013 javascript client object model - get server time

My client machine and server machine has time offset of 2:30 hours. So when I try to retrieve Date/Time field using JSOM, it gives time according to offset. oListItem.get_item("Modified"); So how to ...
10
votes
3answers
12k 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 Web,...
4
votes
4answers
10k views

Get difference in Minutes for DateTime format column

I have a formula for calculated column which gets the date difference in hh:mm format. =TEXT([COLUMN2]-[COLUMN1],"h:mm") But I want to get the difference in just minutes. I created very complex ...
4
votes
3answers
2k views

Set default value of Article Start Date to [Today] with CSOM

I'm struggeling with setting the default value of ArticleStartDate date-time column using PowerShell and CSOM. Bakground: I have a content type, used by a page layout, inheriting from Article Page ...
2
votes
2answers
5k views

Sharepoint 2013 - custom display form - time/date not formatted correctly

I have an issue on my display form with formatting. I have set the language and region correctly - and chosen time and date in a friendly format. When I enter the time and date it all looks fine - but ...
2
votes
1answer
4k 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
3k views

Date column value changes because of DST

A list includes a column "Date" of type Date and Time, Date and Time Format is Date Only. An item is saved via web-service and is set to value such as 2013-04-01T00:00:00Z. When this same item is ...
9
votes
10answers
37k views

Create a Current Date and Time Variable in SharePoint Designer 2013

Is there a way to set or create a date/time workflow variable with the current date and current time in a 2013 SPD Workflow?
3
votes
1answer
6k 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 ...
3
votes
1answer
885 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
2answers
2k views

Format Date using CSR (dd.MM.yyyy)

I´m using SP2013 and i have a Shift Plan which colors the row from TODAY in yellow. var today = new Date(); // zero out the time portion so we will only compare days today.setHours(...
2
votes
3answers
7k views

How to display date in Page Layout in specific format

I am using the following code to display date in a publishing page layout. <SharePointWebControls:FieldValue runat="server" FieldName="Created" id="CreatedOn"/> This displays both date & ...
1
vote
2answers
470 views

Extract data from meta data field and copy to new field

I have a managed term set which provides date meta data for a column used by accounts. They tag a document depending on the period (month and year) it relates to. What I wish to achieve is to have a ...
1
vote
1answer
2k 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
0answers
485 views

Document Library Date/Time gives “Invalid datetime value” error after changing site regional settings

Using Sharepoint Online, I've created a new column on a document library "Expiry Date". This worked fine until I changed the sites regional settings from English (United States) to English (United ...
1
vote
1answer
47 views

SharePoint Filters and Custom Views Total Calculations

I have a Date column where users can enter any date they want, I also have separate column that shows the month of that same date column. I am trying to create a filter that will count how many ...
0
votes
2answers
665 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
1answer
6k views

Why can't I get this calculated field to work?

I'm trying to create a calculated column (text) which contains a combination of 3 other columns. I've asked another similar question but that was a different subject - now I'm trying to do this in a ...
0
votes
3answers
45 views

Simple flow to update a specified time/date field with the current time not working - see screencaps

I have created a very simple workflow that should update any item that is created/modified with the current date-time, leaving all other fields the same. However, the current time is applied to ALL ...
0
votes
2answers
2k views

Showing only last six months in a dropdown

I have a month column (a choice column) in my document library. Its format is, for example, "Jan 2013". I have the following requirements: The month dropdown should always show only the previous 6 ...
0
votes
1answer
6k views

Designer Workflow: “Find Interval Between Dates” action not working

I am testing a default SP Designer 2010 workflow action called "Find Interval Between Dates" located under the "Utility Actions" category. I need to compare the amount of time passed between the ...
0
votes
1answer
3k views

date column validation

Is it possible to validate the end date to be not greater than by 30 days over the start date? So if the Start Date is February 18, the End Date cannot be more than 30 days past February 18. Thank you....
0
votes
3answers
7k views

Formula to show differens between dates without weekends and holidays

If anyone know formula without code in SharePoint 2010 to show differens between dates without weekends and holidays, I'm trying to find solution but no result so far ... I will be veru gratefull for ...