Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [date-time]

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

0
votes
0answers
9 views

Need to show time difference in negative

I need to calculate a difference between two times and it should show negative value if the value is negative. Say Time 1 is 29/04/2019 11:30 PM and Time 2 is 29/04/2019 12:00 PM. I wat the difference ...
2
votes
1answer
1k views

Change Date Format in SharePoint 2016

I want to change the format of date from MM-DD-YYYY to DD-MM-YYYY in list, Gantt charts etc. I have tried one option so far but it doesn't work properly which is explain below: First option: I have ...
5
votes
1answer
2k 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 ...
0
votes
1answer
1k views

Date Column showing “1/1/1900 5:30 AM”

Have created a custom list with below column 1.Title 2.Status (Drop-down column with "In progress" & "Completed") 3.In Progress Time (Date & Time Column) 4.Completed Time (Date & ...
2
votes
1answer
36 views

Working with time in calculate columns

I am working in a calculate column that should calculate the time minus x minutes based on another date-time column. I have a start date column of type date-time and I need calculate that time minus ...
3
votes
3answers
1k views

Date field validation in SharePoint 2007

I need to limit the Date field in a SharePoint 2007 list so the users can enter date from today and up to year after. How can i do it?
0
votes
0answers
22 views

Refinablestring Date Column Range Results using Search Rest API

We have a Document Library in SharePoint Online with Date Column and it was mapped to RefinableString00 Managed property. currently we are getting the search result using the below api url "/_api/...
0
votes
1answer
17 views

Set date column default for specific time on day

I have a date and time column in a SharePoint document library Is it possible for the default value to be a certain time (e.g. 1pm) on the day of creation?
0
votes
1answer
656 views

Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model

I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript. I've tried everything to get those results with query like: "<Where>" + "<...
0
votes
1answer
34 views

How i can set a Date/Time field to be required if a People/group field contain a value

I am working on a custom list inside sharepoint online classic UI. and inside the custom list i have 2 fields:- "ResponsibilityOwner" --> People/Group which allow single value. "...
0
votes
0answers
21 views

How to change the below explained validation from inline style to ms-form validation on migration from SP 2010 to SP 2013?

After migration from SharePoint 2010 to 2013, when we add an element and miss any mandatory field, we should get the validation errors. But in my case, when I fill the Authorized Date field and miss ...
0
votes
1answer
683 views

Saving Publishing Page in edit mode returns “Are you sure you want to leave this page?” dialogue

we're getting some ... interesting ... behavior in IE. Setup We have a page layout based on some content type. Both contain (besides other fields) a DateTimeField which is shown in edit mode. When ...
2
votes
1answer
60 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 ...
0
votes
3answers
1k views

How can I sort this by an actual DATE?

I have a calculated field in a document library that takes the "Modified" property makes a more readable date from it. The problem is, the column is now sorting alphabetically, even though the data ...
3
votes
1answer
5k views

Programmatically (C#) set date field to blank in 2010

I have tried setting my date field to an empty string ("") and setting it to "01/01/0001". Both returned the error "String is not formatted as date time". I have several thousand items across a few ...
0
votes
1answer
720 views

How to calculate the total days between two selected calendar dates

I've startDate = 7/16/2015 and endDate = 7/20/2015. This 2 dates are stored in a SharePoint list. If user select the exact date with the date in SharePoint list, it can calculate the total days = 2 , ...
-1
votes
1answer
21 views

Get Recent date using Javascript

I want to get the Max date in the column Date1. This is my code : function RetrieveLog() { var getItemsUrl = "/_api/Web/Lists/GetByTitle('" + ListName +"')/items?$select= ID,Title,Date1,LastDD"; ...
2
votes
2answers
897 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 ...
0
votes
1answer
18 views

Event Recevier gets wrong date in itemAdding

I have an event receiver in sharepoint online and it is deployed in azure. so i noticed that it is returning the wrong date and have noticed that it gets the previous day if the time is 12:00AM. ...
0
votes
1answer
833 views

Show current DateTime as a Survey question

I have a survey list with some questions. I want each survey to have current DateTime. I used DateTime column and set the default value as Today's Date but when i try to respond to survey the column ...
0
votes
1answer
901 views

Daylight saving time and UTC

Can someone confirm that using UTC date storage in lists can cause problems after summer time ends? I'm in the UK, during the summertime i was in UTC+1. So when i saved a date field using the ...
0
votes
3answers
994 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
877 views

Date and time validation

In my SharePoint 2013 I have 4 columns Start Date (date only), Start Time (Single line of text, max 5 characters), End Date (date only) and End Time (Single line of text, max 5 characters). I want to ...
0
votes
1answer
825 views

Empty date field goes to 1/1/1900 when updating target list with workflow

Say, I have a SourceList with date fields like these DateReceived, DateEntered. If these field or fields are null then in workflow updates the target list item with 1/1/1900 dates respectively. What'...
0
votes
2answers
914 views

Content Search WebPart: query Date and Time field

I have calendar list, Now trying to query items which is greater than Today. so first I have created new managed property with name EventDate and mapped the crewel property ows_EventDate with type ...
1
vote
1answer
899 views

How to Display Correct Times for Users Regardless of Their Time Zones

I have an InfoPath form on my List. One of the controls on this form is called LoggingTest of type "Multiple lines of text". Below are the settings for this column on my control: The purpose of the ...
2
votes
2answers
109 views

Setting a Workflow variable as a long date

I have seen all the suggestions for extracting the day of the week from a long date in a SP workflow. I would love to be able to set my date/time variable to a long date but the system will not let ...
0
votes
1answer
24 views

PowerApp Date formatting

My company uses JD Edwards from Oracle and they store their dates internally as a 6 digit string in this format: CYYDDD where C denotes a century indicator (0 for 1900s and 1 for 2000s), YY denotes ...
1
vote
0answers
18 views

How make publish by date MVC , sharepiont

I am working in site that publish the content by date so, every Thursday I will compare the date that the content approved to this Thursday date if its the same date (dependent on admin diction to ...
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....
1
vote
1answer
964 views

Validating a set of dates in Microsoft Sharepoint

I am trying to validate dates in a task request form that has a column of [Date of Request] (which would be the day that they are adding the task to the main hub. I, then, want that [Date of Request]...
1
vote
1answer
7 views

Sharepoint 2007 - Date diference

i need to determine the number of days between two calendar dates. I have create a 2 columns, the first Date 1 and the second Date 2. The date is chosen by clicking on the calendar. What i require ...
0
votes
1answer
945 views

How can I align Date modified with Date last saved?

I still have this problem with Sharepoint 2010 and Windows 7, i.e. Excel or Word documents edited from within Sharepoint display an outdated Date modified in Windows Explorer view. However, the 'Date ...
1
vote
1answer
996 views

How to change date formating to yyyy-MM-dd

I have got this code: dzienStart = Convert.ToDateTime(properties.AfterProperties["DzienStart"]).ToLocalTime().AddHours(-1.0); dzienStart = Convert.ToDateTime(dzienStart.ToString("yyyy-MM-dd")); ...
2
votes
1answer
1k 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 ...
0
votes
2answers
1k views

Setting End Date to same as start date

I have a list that I created to track start/end times for activities. I'd like to set the form so that when the user enters the start date it populates the end with the same date so that users ONLY ...
5
votes
1answer
1k views

SharePoint JSOM datetime values in different timezones

I am working on a solution (on SharePoint Online) which is used by users in different timezones. SharePoint site is configured for "W. Europe Standard Time". Following occurs: A user from US creates ...
3
votes
1answer
1k 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 ...
0
votes
1answer
1k views

Time Difference in SP Calculated Column excluding weekends

I have two dates (Initial Date & End Date) both date and time format in a SP List. I need to calculate the amount of days between both of them excluding weekends. I already have the formula in a ...
0
votes
1answer
43 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
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"). ...
3
votes
3answers
3k views

SharePoint views - Filtering by date and time

We have a custom web-part that uses a View to filter Procurements (Tenders) by date. We are trying to filter the view using the [Today] function but from what I gathered it only uses the Date and ...
1
vote
1answer
46 views

SharePoint 2013 Column Validation override for site owners

I have a list where user's can't edit a column if =[Delivery Date/Time]>(TODAY()+5) I have this validation on Delivery Date/Time column. I need admin/site owner needs to edit the list no ...
3
votes
3answers
1k views

Concatenate two dates to one column

I am pretty basic user of SharePoint 2013 and I have this problem: I have to create a calculated column with two dates in them to look like this: From 21/2/2016 to 5/3/2016 but whatever I try, the ...
0
votes
1answer
27 views

Calculated Field to show difference of hours as value

Hello I have three fields hours1, hours2 and total hours. Total hours is calculated fields based on the sum of hours1 and hours2. I use the formula =VALUE(TEXT(total hours,"hh"). It works if sum of ...
0
votes
1answer
86 views

SharePoint online, MS-Flow and calculated date time column #name issue?

I've got a current staff list with a StartDate (datetime) column and two calculated columns: 'DaysWorkedAt', 'YearsWorkedAt' I have an MS Flow workflow attached to the new employee list on new item ...
1
vote
2answers
4k 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")...
0
votes
2answers
189 views

sharepoint get list item returning wrong date time

i noticed while testing that the sharepoint get list item call i am making through pnp sp is wrong. i tried going to the endpoint url directly to check but the return date is the same (wrong date) . ...
0
votes
1answer
111 views

wrong datetime returned in caml query in c#

I have custom list in sharepoint 2016 on-premises. There are several columns in DateTime type. I need to query this list in C#, but when I run my query I get wrong dates - I get always the day before ...
0
votes
1answer
34 views

How to Add time in SharePoint List?

I am wondering how to add time field in sharepoint list which will allow users to enter time. Is this possible in SharePoint? If Yes, How can I achieve this?