Questions tagged [date-time]

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

Filter by
Sorted by
Tagged with
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 ...
1
vote
0answers
42 views

SharePoint Column Conditional Formatting - Applying CSS classes to a date field using a nested IF statement

Apologies, I am relatively new to SharePoint/JSON, So forgive me if I am not seeing the obvious. I would be INCREDIBLY grateful if someone would help. I would like to apply conditional formatting to ...
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 & ...
4
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?
1
vote
1answer
20 views

How to validate date in datepicker with jquery (no with validation column)

I have two date-pickers in the same list but each have a different validation rule (in configuration of column) and the user can choice set date in one or other field on the form (but not required to ...
1
vote
3answers
44 views

I want to display a blank field in the calculated column if both the reference fields are blank

I want to display a blank field in the calculated column if both the reference fields are blank, but SharePoint displays the default date as 30-Dec-1899. Formula I used in Calculated column: =IF(...
1
vote
1answer
24 views

Retrieve Date from Date/Time Field in SharePoint List with Javascript?

I am trying to pick up the date for each item in a list but I cannot seem to figure out all to get the value. I am using: var startDate = listEnumerator.get_current().get_item('Start_x0020_Date')
0
votes
1answer
28 views

List view grouped by type “Number” then by type “Text” does not expand to show entries in SharePoint Online

List view is grouped by field "Created year" of type "Number" and then by field "Created month" of type "Text" does not show entries while trying to expand the grouping. Both are calculated columns ...
0
votes
1answer
26 views

Can I customise the time shown in the datepicker?

I have a scenario where users are to book sessions with date and time. Currently, I am trying two ways to enforce unique values for date and time. I added a date picker. I added a formula to validate ...
0
votes
1answer
657 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
704 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 ...
1
vote
1answer
970 views

Daylight saving time and UTC

Can someone confirm that by using UTC date storage in lists it can cause problems after summer time ends? I'm in the UK and during the summertime I was in UTC+1. So when i saved a date field using ...
0
votes
1answer
27 views

Calculated column to determin a due date of a record

I'm looking for some help. I'm trying to setup a calculated field to determine a due date of a record. The due date needs to exclude weekends, and also is dependent on two addition columns. ...
1
vote
2answers
14 views

Get hours in FormatDatTime by Flow

I want to retrieve the date of today not in utc but in central France to compare it with the time of a calendar event outlook ?
1
vote
0answers
34 views

Odata query returns 401

I'm working with the SharePoint 2016 OnPremis OData Rest Api. The filter parameter is defined followings: $filter=Art/Value eq 'aString' and year(Received) eq 2019 Art is a choice value and Received ...
0
votes
1answer
737 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
vote
1answer
41 views

SharePoint Online Date field with calculated default is emptied after an update

On a Document Library, I have a Date field with a calculated default of Today+90. This works as expected - for example, if I create a new document on "25/06/2019", the calculated default is 23/09/...
0
votes
1answer
896 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
56 views

SharePoint Date wrong in Power Bi

I have a list in sharepoint where in create items with date and time amongst other data. Eg. I have one where I entered the date 14-06-2019 05:00:00 Now when I pull this into Power Bi the date is 14-...
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
2answers
1k 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 ...
0
votes
1answer
964 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
0answers
20 views

SharePoint 365 List DateTime column needing no Time Zone affiliation

I have a SharePoint 365 custom list for my configuration team to receive requests from our internal business customers. There are date time fields for start date and end date of the configuration ...
0
votes
1answer
869 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'...
1
vote
2answers
34 views

Display The time an items has been in a status

Looking to how to display the time an item has been in a status since it was last modified. =CONCATENATE(IF(INT((Modified-Created)*24)>1,INT((Modified-Created)*24)&" hours ",IF(INT((Modified-...
1
vote
1answer
1k 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 ...
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
981 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]...
0
votes
1answer
997 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 ...
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 ...
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 ...
3
votes
1answer
716 views

Need help comparing two dates with times

I'm trying to compare two dates with time. I'm able to compare just the date, but when I add the time element it doesn't work. I'm not sure what the correct format should be. <xsl:if test="ddwrt:...
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 ...
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 ...
9
votes
10answers
35k 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?
2
votes
1answer
73 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
1answer
29 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 ...
2
votes
1answer
47 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 ...
0
votes
0answers
39 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
34 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
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
27 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
3answers
2k 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
6k 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 ...
-1
votes
1answer
26 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
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 ...
0
votes
1answer
19 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. ...
2
votes
2answers
139 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
25 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 ...