Questions tagged [date-time]

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

Filter by
Sorted by
Tagged with
1
vote
2answers
1k 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
175 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
1answer
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
413 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
190 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
45 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
146 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
105 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
175 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
66 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
71 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
73 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
433 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
496 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
40 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
81 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
583 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
292 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
311 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
110 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
582 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
60 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(...
3
votes
1answer
1k 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
57 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
72 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
71 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
550 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
754 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
87 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) ...
3
votes
2answers
2k views

Query the year from a date field in CAML Query

I have a SharePoint 2013 list in which I have a date field say Formatted Date, now using CAML Query I need to retrieve only the records which have year 2017 in the Formatted Date.PFB my code: $()....
1
vote
1answer
360 views

Site Regional Settings time zone vs User Profile time zone - how does this work

I'm working to define requirements for a site collection with 50+ sub-sites. The company is based in the Central Time zone. We will have internal and external users, but all will log in to access the ...
0
votes
0answers
121 views

Current time in sharepoint designer 2010

I create a workflow in SharePoint designer 2010. For each task I have to create a event in a calendar. To get a current date and time I modify list item and use "Pause for 1 min" (without pause, ...
2
votes
2answers
2k views

How do I add hours to Now() after converting it to a text value?

I have a calculated field that shows the text value of the current hour, so I'm using: =TEXT(Now(), "hh") Unfortunately, it's showing this value in Pacific time, so I'd like to add 3 hours to ...
0
votes
3answers
974 views

Using Moment to format a date from a Sharepoint list

Afternoon I'm new to using Moment and need to format a date from SharePoint in JavaScript. The variable is LifeCycleStart and I don't know the right way to format it and drop in Moment. Here's what ...
1
vote
1answer
1k views

SharePoint Conditional Formatting Date Column

I've been trying to create a Conditional Color column for dates that are expired. The expired dates should be red and the dates that are not should be clear. I tried to use the code from http://www....
0
votes
1answer
304 views

Calculated column to show differece between start time and end time

I have two date columns in a custom list: Start time and End time, both are set to today's date and just select the time. Now I want to add a new column that will automatically show the subtraction ...
0
votes
1answer
63 views

SharePoint Calculated column to Check If today is 14th date

I have date time column called Today. I'm trying to create calculated column which check today is 14 Value for Today column is 4/13/2017 I m trying to check that is today is 14. means like this (4/...
0
votes
1answer
336 views

incorrect of sharepoint 2016 datetime field value

I have just created list and in that list I create a datetime field, and I developed a C# program to get the list data, but when my program get datetime field value, have a wrong, in my sharepoint ...
2
votes
0answers
25 views

Can we compose REST query which first apply some function on item then compare?

I have a date which is in Indian time zone, my SharePoint Online site is in different time zone. Now I have a rest query which filters the record. SiteUrl/_api/web/lists/getbytitle('ListName')/items?$...
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 ...
4
votes
3answers
286 views

Sum of two Time columns

There are two calculated columns that display times of two date columns. I want to sum those two "time" columns. Any suggestion is greatly appreciated. Example: column 1: 16:35 column 2: 14:00 So, ...
0
votes
2answers
340 views

Whats wrong in given caml query?

I am trying to get the data based on some datetime string using CAML query. Here is my CAML query: <View> <Query> <Where> <And> <Le&...
3
votes
3answers
3k views

Difference between two dates in hours

In SP list there are two date/time columns, column A and B. I want to calculate difference in hours between those two dates, but only on working hours. My working hours are between 8AM (08:00) and 4PM ...
1
vote
0answers
86 views

How can I create a DateTime for a specific time with the correct UTC offset in an SP2013 workflow in VS?

I'm trying to pause a workflow until 8 AM on a specific day. I am on the East Coast of the US: UTC -5. I can create a DateTime object with a time of 8 AM like this: new DateTime(DateTime.UtcNow....