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
0
votes
1answer
47 views

SP List dropping date format

I have a sharepoint list that has a timestamp in one of the columns. I'm adding the timestap via MS Flow. I need the format to be yyyy-MM-ddThh:mm:ssZ (so i can compare later in a REST call) but ...
0
votes
2answers
49 views

limit edit item in list to 12 hours

I have a SharePoint 2016 team site with a list that will be used for a shift log. I want to limit the ability to modify a log to only be editable for 12 hours. Currently I am using list validation ...
1
vote
2answers
90 views

Number of working hours between two dates and times

I'm using this formula in a calculated field to calculate the number of work days between 2 dates, but I need it to be more specific and calculate the number of work hours: =IF(NOT(ISBLANK([Return ...
0
votes
1answer
20 views

Check a box based on last Monday of the month?

Is it possible to have a check box automatically tick based on a date if that date is the last Monday of a month? How would one accomplish this? Thanks.
1
vote
0answers
49 views

Checkbox with User Stamp when changed

I am still a beginner in SharePoint and am looking for some guidance (I can do this in Excel, but can't figure out how to do it in SharePoint). FYI - I am stuck using SharePoint online (not ...
0
votes
1answer
53 views

Time Differences

I have two columns in SharePoint that are each Single Line of Text columns that require the user to enter the start and end time of an audit, utilizing a 24-hour clock. For example, the User enters "...
1
vote
2answers
35 views

Retention Policy for Academic Years not Calendar Years

We are wanting to add a retention policy for a site that holds academic material. The retention will be current year plus 5, this is not calendar year. So if a document was created on september 2009 ...
1
vote
1answer
82 views

How to resolve rounding error in calculated column involving Date and Time?

I have a custom list in SharePoint with two Date and Time columns, namely StartTime and EndTime. Now I want to calculate the difference between them, so I created a new calculated column Length and ...
1
vote
1answer
68 views

Time is missing from a 'Date and Time' metadata field: Calendar vs. document library

I haven't been able to find any articles or forums on this unfortunately. Currently, our organization schedules events into an event calendar, which prompts a workflow. The user is asked to input ...
0
votes
1answer
22 views

SharePoint Online, “Dec 31 [this Year]” calculated field - how?

Trying to create calculated field for SPD workflow. There should be yearly reminder (I wanted to compare "Date workflow started" with this field..). Tried to create Date field/Calculated field with ...
0
votes
1answer
21 views

SharePoint Retention Policy - trigger once a year on a particular date - Dynamic year value

Looking for some ideas: I need to trigger a retention policy in a particular document library once a year on the same date. The challenge is setting the year dynamically. Could I use a date\time ...
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' ...
1
vote
3answers
1k views

How to set Date column with default value as calculated value?

One date time column: Target date Requirement: Need to set default 'Target date',5 Days ahead of item creation date. I have tried this:= but it is not working =[Target date] = [Created] + 5 Kindly ...
0
votes
1answer
121 views

Why sharepoint adds automaticaly one hour

I have Date and time field, where I set default date and time, f.e. 1.1.2018 10:00 AM. When I add item due to new item button, date and time is set right and I can save it. But when I use quick edit ...
1
vote
2answers
467 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
2answers
2k views

How do you handle “#NUM!” in a SharePoint calculated field?

When you use DATEDIF in a SharePoint Calculated field and the result is negative the function returns #NUM! how can I detect that value with an IF to branch around it? =IF(DATEDIF(NOW(),[Proposal ...
0
votes
1answer
258 views

How to get prior Thursday of a specified date

I'm working on a calendar week that starts on Thursday, not Sunday, and it's causing me a few fits that I hope someone can assist me with. How do I take a date from a date that was entered into a ...
1
vote
1answer
1k views

Calculating Week Number in calculated field

I'm trying to calculate the week number based on a fiscal year starting on November 1st with moderate success. Current formula: =INT(([Project Start Date]-DATE(YEAR([Project Start Date]-WEEKDAY([...
2
votes
2answers
2k views

Is it possible to clear a date time field using a workflow

It seems to me that for some utterly stupid reason, it seems as though one cannot clear a date time field using a workflow, although one can clear it manually in the user interface. Makes absolutely ...
1
vote
3answers
523 views

How to get the site lastvisted time of the user in SharePoint 2013?

I need to get the site last visited time of the user's, and need to update that time in userprofile properties. I am not sure any api or in build functionality available. Pls suggest me some idea to ...
3
votes
1answer
221 views

Calculate Hours Worked Per Week

I'm currently using two lists, one stores tasks [Task List], the other stores the hours worked for completed tasks [Time Sheet List] When a user marks a task as complete, it creates a corresponding ...
0
votes
1answer
49 views

Get Items Expiring in Next 180 days

I am looking to create a view where users can pull report of expiring licenses 180 days from now. I have [End Date] set as expiring date. How can i create a view where it will pull data expiring 180 ...
0
votes
0answers
161 views

After change regional settings, pages with SPFx webparts gives unexpected error has occurred

After change regional settings in SharePoint 2016 On-Premise server to Bulgarian, Macedonian оr other Locale I have following error: Error from log file by corelation ID is: Message : System....
0
votes
2answers
124 views

Adding list item in SharePoint List gives an error on date format

i have an issue with all my lists in SharePoint, giving error when adding an item to list "You must specify a valid date within the range of 1/1/1900 and 12/31/8900." I have checked regional settings ...
1
vote
1answer
191 views

Using Infopath to build list form, but I want to only use the “time” field from the “Date & Time” preset field?

I am in the process of building a list form using InfoPath for a team's intake form. There are two separate columns: Validation Date Time Required Validation Date will be a date stamp (Jan 1, 2018),...
1
vote
1answer
81 views

SharePoint Online XML Field DateTime default on minute and NOT nearest half an hour

I have a Field (Site Column) element which is type DateTime <Field DisplayName="Created" Name="Created" StaticName="Created" Type="DateTime" ID="{28C9A5E9-513C-415A-8C41-E7A3D767EABD}" Group="...
2
votes
2answers
1k views

Incorrect date/time shows in SharePoint calendar

I am trying to create a column that will display how many days a calendar entry will last for - so for example if we have visitors on site from 25/10/2017 to 26/10/2017 it will display "2". Currently ...
1
vote
0answers
25 views

How to include a site column for year that can be populated using the standard calendar

I am working on an on-premises SharePoint 2013 farm. We need to have a site column which represents the "Date Published" for books and papers where we need to store a value representing the year. Is ...
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
75 views

Function always return same value instead throw else clauseif condition is not valid

I have this query running from JSLink into list. It get current time from moment.js and compare date with sharepoint column ctx.CurrentItem.Cumplimiento; and return result into column ...
0
votes
1answer
468 views

How to get items created in month of Feb using REST query irrespective of year [duplicate]

I want to create such a query using REST that returns me items created in the month of February. To do so I searched for the functions we can implement to the REST query and I have found month() ...
1
vote
1answer
578 views

Date value in SharePoint is one day off while retrieving

I am saving a DateTime value in one of the field in SharePoint list : //request is an entity that has all he fields in the list, I am only showing DueDate in the below code if (txtdatepicker.Text ...
1
vote
1answer
47 views

Collect Data from a User - Date and Time (without seconds)

I am creating a workflow in Sharepoint Designer 2010. In one of "collect task" I have a field "Meeting date": Information type: Date and Time Display format: Date and Time My problem is that in ...
0
votes
2answers
91 views

Format sharepoint server time with javascript

I retrieve server date using javascript using JSLink like: var currentServerDateTime = new Date(_spPageContextInfo.clientServerTimeDelta); But I want it into format "dd/mm/yyyy", how can I achieve ...
1
vote
2answers
649 views

Get date format of current site which is set in regional settings using JSOM

I need date format of site, I can get date separator using get_regionalSettings() and get_dateSeparator() . I tried get_dateFormat() but it returns "1". I need to know date format of particular site ...
2
votes
1answer
2k views

Add 2 hours to calculated Date and Time field

I have calculated Date and Time field with Formula =NOW() is possible to add 2hours using formula?
1
vote
1answer
315 views

SharePoint 2013 Content Query Tool Part - How to format a “Date and Time” display field?

In the Content Query Tool, I'm pulling data from a task list, and for the Description, I want to display the Due Date. In the list itself, the Due Date is set to Date Only, Friendly Display Format (ex....
0
votes
1answer
355 views

CAML to Return rows Where Created is Between 2 dates

The below query returns the entirety of the List, instead of those which fall inside the correct date range. I have tried querying with and without a time added to the date. CamlQuery ...
1
vote
1answer
118 views

Calculated Date [Sharepoint Online]

Currently having an issue with a calculated date column when the field is not filled in. Displays the date as December 1899. Current formula is: =TEXT(YEAR([Closed Date]),"00")&"-"&TEXT(...
5
votes
1answer
632 views

Is there a way to change the Date format inside SharePoint sites to be shown as DD MMM YY (i.e. 25 March 2017)

I am working on a sharepoint farm on-premises 2013. currently we set the following for the regional settings:- Where all the date fields are being shown in this format dd/mm/yyyy for example ...
0
votes
0answers
1k views

REST API Date Time Zone issue

I am fetching records from the list using rest api by filtering date field in it. however i am getting a different result from different time zone. any kind of help will be appreciable. var today =...
0
votes
2answers
67 views

Concatenating a date field to a drop-down based time field

I am trying to create Start Date/Time and End Date/Time fields. Here are my parameters: Start Date STime (drop down) End Date ETime (drop down) Start Date/Time (calculated) =concat(substring-before(...
4
votes
1answer
2k views

Time Difference Formula in Calculated Column

How Can I achieve displaying time difference between two type "date and time " columns? I want to put the time difference in another column type "based upon calculation" of those two. I want to ...
2
votes
1answer
59 views

Can we convert Sharepoint date/time to XSD date/time

I have requirement to convert SharePoint date and time to xsd date and time. can we do this in SharePoint. Any insights would be great.
2
votes
1answer
73 views

Calculated Column that will trigger the word “expired” in another column

I am looking to create a calculated column that will trigger the word "expired" in another column if the date is less then or equal to today's date. Do you know what formula I would use for this?
2
votes
1answer
76 views

3rd Tuesday Calculated Column not working when there are 5 weeks in the month

Looking for some assistance on why my calculated column formula doesn't work when there is 5 weeks in the month. I have one column called Current Patching Date (date/time field) - stores a date I ...
1
vote
1answer
601 views

Update the display format value with CSOM

I have SharePoint list hosted in SharePoint online. I need to change the display format for the modified filed to standard from friendly using CSOM code. I am able to do it through UI. Below is the ...
0
votes
1answer
2k views

How to calculate Days, Hours and minutes between two different dates and times

I have a Start Date and Time column and a End Date and Time column, I also have a calculated column using a Single Line of Text formula: =TEXT([End Date and Time]-[Start Date and Time],"d:hh:mm"). ...
0
votes
1answer
859 views

How to change list item date time format type using c#

I am making a sharepoint web appplication. when I show the data from sharepoint lists, I want to change DateTime format type. For example, "Created" item showed like this now [2017-06-15 PM 3:23:33] ...
0
votes
1answer
98 views

Date/Time Difference (Workhours/Workdays only)

I have a rather complicated (to me) Date/Time question. I have a multi-step workflow, and am trying to build two calculated columns to track the elapsed time in business hours (M-F, 0800-1700) ...