Questions tagged [date-time]
Represents an instant in time, typically expressed as a date and time of day.
456
questions
0
votes
1answer
16 views
Filtering by date isn't working properly
I have some struggle viewing lists with a Group By.
The list contains documents that belong to a certain event. Therefore, we added a lookup field which points to the date + start time from the ...
1
vote
1answer
23 views
Workflow Date/Time variable is off by 4 hours
I am using SharePoint Designer 2013 to write a workflow on SharePoint 2010.
My time zone is UTC-05:00 and that is the time zone in my site's regional settings. I have a list that has a look up from a ...
2
votes
2answers
29 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 ?
...
1
vote
1answer
22 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
2answers
51 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 ...
2
votes
1answer
71 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 ...
2
votes
1answer
28 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 ...
1
vote
1answer
38 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 ...
0
votes
1answer
15 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' ...
0
votes
2answers
31 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 ...
0
votes
0answers
33 views
Search, Dates & Timezones - Can out of the box search on a SharePoint site be made locale aware?
When working with Date columns on a SharePoint list, SharePoint assumes that dates inserted by the users are relative to the current time zone (a sum of the site specific regional settings and any ...
0
votes
0answers
11 views
Creating a Date Column to display in the “Friendly” Format
I'm confused. I have a column "Date Chart Requested" and at first it did display the dates as "5 days ago" which is exactly what I want. But after further tweaking of the custom list, it no longer ...
1
vote
1answer
78 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 ...
1
vote
1answer
31 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....
0
votes
2answers
103 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 ...
0
votes
1answer
24 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 ...
0
votes
1answer
39 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
68 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
25 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
76 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
28 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
164 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
95 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
222 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
337 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
55 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
31 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
244 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
33 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
42 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
29 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
43 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
48 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/...
1
vote
1answer
630 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
94 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
126 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
50 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
70 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
74 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
53 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
1answer
38 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
67 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
21 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
29 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
16 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
65 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
45 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
326 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 ...
