Questions tagged [date-time]
Represents an instant in time, typically expressed as a date and time of day.
1
vote
1answer
41 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
26 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
35 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
67 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
42 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
28 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
24 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
19 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
31 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
18 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 ...
0
votes
0answers
66 views
Find interval between dates returns negative values
I want to calculate ticket age on my sharepoint list so there are 2 fields "Date Reported" and "Date Closed" in date format dd/mm/yyyy. In sharepoint designer I created a workflow to calculate ticket ...
1
vote
1answer
36 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
149 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
33 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
412 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
78 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
51 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
361 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
21 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
14 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
0answers
35 views
Create a Listview based on Date Groupings and Sorting. Date is a calculated Field
I would like to group a list by Month Year in SharePoint online. I've a calculated field that returns the date as text in the format "YYYYMM¤MMM-YY" e.g. "201806¤Jun-18" to allow sorting in the ...
0
votes
0answers
132 views
RegionalSettings.TimeZone.LocalTimeToUTC resp. UTCToLocalTime wrong?! (CSOM)
I came across a weired problem with the LocalTimeToUTC/UTCToLocalTime functions of the TimeZone class (C#, CSOM v14.0.4762.1000).
The results are just completely wrong. I couldn't find any other page ...
0
votes
1answer
37 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
47 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
19 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
43 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
49 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
31 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
52 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
44 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
0answers
26 views
Add undefined number of workdays to date calculated column
In custom list, I have Start date which is date column, Number of workdays is number column, it is undefined, may vary from 1 to N, user should enter it's value, and in the end I have Finish date ...
0
votes
1answer
17 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
15 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
138 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
778 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
0answers
292 views
Custom Formatting Modern Lists - Problem using Date Field
I am trying to use the new modern list custom formatting capabilities (in JSON) for an email template (see: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#...
0
votes
1answer
77 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
220 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
733 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
103 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
709 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([...
1
vote
1answer
912 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
191 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
121 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
38 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
124 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
81 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
148 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),...
