Questions tagged [date-time]
Represents an instant in time, typically expressed as a date and time of day.
0
votes
1answer
11 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
0answers
17 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
30 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
24 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
30 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
24 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
44 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
25 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
22 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
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. ...
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
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
1answer
8 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
49 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
28 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
109 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
248 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
154 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
38 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
28 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
0answers
48 views
Prevent timezone issue and save date time as is in SharePoint using JavaScript
This maybe a common issue but my requirement is below.
1) user selects date and time using Bootstrap datetimepicker
2) If user selects 15/9/2018 12:03 PM, it should save as is
Currently the timezone ...
0
votes
1answer
39 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
44 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
222 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
51 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
1k 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
29 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
104 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
87 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
800 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 =...
0
votes
0answers
15 views
Making a view in a calendar based on Dates and Times in Sharepoint 2010
I have a on call calendar that I use an event based view and it uses both day and time between each day. Each item starts at 8am and rotates weekly. I created a view that only shows the items with an ...
0
votes
1answer
45 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
66 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
48 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
52 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
33 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
68 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
58 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
21 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
16 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
170 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' ...
0
votes
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
104 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
353 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 ...
0
votes
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 ...
