Questions tagged [date-time]
Represents an instant in time, typically expressed as a date and time of day.
551
questions
2
votes
2
answers
43
views
DATEDIF Calculation losing a minute
I have a timesheet for users to enter Start Time, End Time and Breaks. I've created this calculation to total the number of minutes worked. However, sometimes it loses a minute. How do I fix this ?
...
- 21
1
vote
1
answer
24
views
multivalidation in sharepoint list [closed]
I am working on sharepoint 2016 and having issue in applying multiple validation between date column
Column A should not be less then Column B
Column F should not be less than Column C
Column E ...
4
votes
2
answers
925
views
Calculated column to show status if another has a value
I have a SharePoint list with a completed date column. I wish to have a calculated column called status so when the completed date column has a date in it, it shows "Closed" and when it is blank it ...
- 57
2
votes
1
answer
1k
views
How to use - SPUtility.GetSPField to set date
The script does not work. I have to write the date value in the field (I tried to do both a regular text field and a Date field) Date2 As it seems to me because of the wrong name. But maybe something ...
- 21
2
votes
1
answer
316
views
SharePoint color formating
I have a Date column in the list and it represents Expiry date.
I need the field to be colored red if the date has passed, orange if the expiry date is less than 30 days, green if the date is more ...
- 23
1
vote
1
answer
198
views
Date Difference in minutes SP Calculated Column
I have a SharePoint Calculated column that is supposed to calculate the difference in hours and minutes between two dates.
This is the expression I am using for that:
=TEXT([IN/OUT Time]-[Staging ...
- 13
0
votes
1
answer
322
views
Date is correct, but String is not being recognized as a valid datetime
I use this to get the current date with one month added to it:
var date = new Date();
day = date.getDate();
month = date.getMonth() + 1;
month = month + 1;
if((String(day)).length == 1)
day = '0' ...
- 105
0
votes
2
answers
777
views
Display a date field in a specific format as single line of text using calculated column
I Need the Right Formula for the following Problem:
I got a column that contains only date but sometimes it contains no Information.
=DAY([AB])&"."&MONTH([AB])&"."&YEAR([AB])
This ...
- 1
1
vote
1
answer
192
views
If calculated value column exceeds 24 hours
I got this calculated column that shows values of "hh:mm:ss". But i've noticed that if its exceeds 24:00:00 it will restarts to ex. 01:00:00..
Is there any way to make a validation or format the ...
- 129
1
vote
1
answer
150
views
Calculating Fiscal Month
I've seen a number of calculations for fiscal year and quarter, but am hoping someone can help me a calculated column for fiscal months. Our company's fiscal months run from the 29th through the 28th....
- 11
0
votes
2
answers
1k
views
Calculated Column Field Date
I need to calculate date based on other column
I'm using =Date(Year([endDate]),1,1) in a calculated field which needs to return data as DateTime, but it is giving me error:
The formula contains a ...
- 13
0
votes
1
answer
1k
views
How can I make a field visible depending on the content of another field?
I have a PowerApp which is working really well so far, it is based on a SharePoint list which holds the data. There is a date field (Paid Date) which defaults to 31/12/2001 for some reason, and I want ...
- 65
0
votes
1
answer
314
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.
...
- 171
0
votes
1
answer
391
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
2
answers
34
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
3
answers
568
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 ...
- 195
0
votes
1
answer
74
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 (...
- 25
0
votes
3
answers
3k
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 ...
- 53
0
votes
1
answer
2k
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 ...
- 1
1
vote
0
answers
616
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 ...
- 53
1
vote
1
answer
2k
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
3
answers
2k
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
1
answer
72
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
1
answer
1k
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')
- 35
0
votes
1
answer
170
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 ...
- 100
0
votes
1
answer
111
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. ...
- 11
1
vote
2
answers
184
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 ?
- 11
2
votes
0
answers
90
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,189
1
vote
1
answer
200
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/...
- 658
1
vote
1
answer
11k
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-...
- 157
0
votes
1
answer
1k
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
1
vote
2
answers
1k
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-...
- 11
0
votes
1
answer
270
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
0
answers
318
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/...
- 2,856
0
votes
1
answer
433
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
1
answer
117
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
1
answer
83
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
1
answer
303
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";
...
- 523
0
votes
1
answer
38
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. ...
- 284
1
vote
0
answers
23
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 ...
- 31
0
votes
1
answer
41
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 ...
- 295
1
vote
1
answer
24
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
1
answer
156
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 ...
- 11
0
votes
1
answer
153
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 ...
- 15
0
votes
1
answer
395
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 ...
- 149
0
votes
2
answers
2k
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) .
...
- 284
0
votes
1
answer
834
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 ...
- 73
0
votes
1
answer
3k
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,057
1
vote
1
answer
109
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 ...
- 43
0
votes
1
answer
231
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 ...
