Questions tagged [date-time]
Represents an instant in time, typically expressed as a date and time of day.
442
questions
0
votes
1answer
17 views
SharePoint 2013 Get difference between two dates in days using JavaScript/J query
I want to get the difference in days between two dates. One date is from a List item input by User. The second day will be "Today". get the number of days from the date input by user and current day.
...
0
votes
1answer
46 views
Calculating “Task Aging” without weekends
I am calculating the number of days a task is aging.
This works great:
=DATEVALUE(TEXT(NOW(),"mm/dd/yyyy")) - DATEVALUE(TEXT([Created],"mm/dd/yyyy"))
However, I need the counting to STOP when the ...
0
votes
2answers
21 views
Calendar Appointment View
Am looking for some help please with how to amend a calendar i've created to show Public Holidays so it shows the title only for an appointment and excludes the start and finish times.
Thanks for any ...
1
vote
3answers
23 views
SharePoint 2013 calculated column -compare dates
I thought this is easy but somehow I didn't get this right.
I entered the following formula in the calculated column but the outcome is incorrect.
For example, when [Target_Finish]=10/10/2019, the ...
0
votes
1answer
27 views
Calculated Column Not Displaying Anything
I have this really odd issue that works in 1 document library (first image) and doesn't for another (second image).
I have 2 columns, column 1 called Published Date (Flow) that is of type string (...
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
1answer
34 views
Exclude weekends
I am working on a vacation calendar project.
I have a custom lists with 2 columns, one being StartDate and the other NumberOfDaysTaken.
I am using a simple SharePoint formula (=FromDate + [How many ...
0
votes
0answers
10 views
SharePoint 2013 Convert time pulled by JavaScript to different time zone
I have a text column in a list that receives the value of a JavaScript timer that's attached to a SharePoint survey that populates the column in this format:
2019-08-28T16:56:19.531Z
Can I create an ...
1
vote
0answers
83 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 ...
1
vote
1answer
34 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
48 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(...
0
votes
1answer
27 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 ...
1
vote
1answer
54 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
29 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
31 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
19 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
36 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 ...
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
160 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-...
0
votes
1answer
33 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 ...
1
vote
2answers
39 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-...
0
votes
1answer
35 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 ...
0
votes
0answers
48 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
46 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?
2
votes
1answer
48 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
28 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
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.
"...
-1
votes
1answer
30 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";
...
0
votes
1answer
20 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. ...
1
vote
0answers
19 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 ...
0
votes
1answer
26 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
1answer
10 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 ...
1
vote
1answer
59 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 ...
0
votes
1answer
30 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
205 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 ...
0
votes
2answers
405 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
248 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
89 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?
-1
votes
1answer
29 views
How to make a column that color codes based on how old items in the list are
I am trying to make a column for my sharepoint list that is color coded based on how old items in the list are(i.e. if items are less than 1 day old there will be a green circle, less than 2 days but ...
1
vote
1answer
32 views
Jquery to display days since modified in list view
I have found plenty of examples on using a calculated column to display days since created. That was a simple excel formula in a calculated column. I need to display days since modified that updates ...
0
votes
1answer
50 views
Start time field calculations on calender events fails on full day event entries
I think I have found a bug in Sharepoint regarding date fields and calculations. Here is how to replicate:
Make a sharepoint event/calendar list (where items have a starttime and end time)
Make sure ...
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
1answer
315 views
Filter dropdown/lookup field based on date
I have a Secondary List(B) that my Primary List(A) uses to populate a field in InfoPath called 'Current Pay Period' which is a drop down. List B contains a calculated column to display dates since ...
3
votes
1answer
97 views
Individual column Validation Based Off The Previous Date Columns
SharePoint Online Classic View
Really need some help with this.
I have a custom list with 8 visible date columns
Column name examples: Create Date, Start Date, O365 Queue and Date Closed.
Create ...
1
vote
2answers
2k views
Calculated column comparing two dates
I can't seem to get my formula working.
All I need is to compare 2 date fields:
The out of the box [Modified] and a custom [Published Date].
The published date is empty until filled by a workflow. ...
2
votes
1answer
30 views
Accurate count of Specific Item entry
Ultimately my goal is to get an accurate count of how many tickets were created with in the last 30 days using a created view.
I have four Date columns:
Create date | Start Date | Close Date | Today
...
1
vote
0answers
134 views
How to validate non-clashing time ranges on items submitted through PowerApps?
I have a SharePoint list with a start time and an end time, which will be entered through a PowerApps app.
One of the core rules is that those time ranges should not clash, similar to a meeting room ...
1
vote
1answer
108 views
Calculated Column Syntax nested DATEIF and ISERROR
This is for SharePoint Online
I have a calculated column that takes info from 2 date columns and calculates the number of days. Some times one of these columns wont contain data. This will then ...
2
votes
1answer
1k views
CAML query compare DateTime in UTC
How do I get files using CAML query from SharePoint Online site filtering them by Modified date in UTC?
When documents are created or updated on site's list they get the Modified DateTime set to site'...
0
votes
1answer
24 views
Calculate dates between now and a specific date
I am trying to have a calculated item between two dates. What I am hoping to do is, get this item to calculate the date difference between now and another date (provided by the submitter)
I tried =...
