Questions tagged [date-time]
Represents an instant in time, typically expressed as a date and time of day.
467
questions
1
vote
1answer
33 views
Calculated Column - Days Difference - Syntax Error
I have a SharePoint List and I'd like to have a column to calculate the days it take to solve a ticket (Solution date - Submission Date).
I tried to create a calculated column, by using a formula = ...
0
votes
2answers
33 views
MS Flow: ticks function behaves different if fed with a string than with a string variable containing the same string
Addendum/Preface
I tried a lot to process a date in the form yyyy-MM-dd coming from two columns of a custom list. I read dozens of articles about dealing with dates in flows and processing SP lists ...
0
votes
0answers
10 views
How to compare dates using Flow properly / Date validation in calendars
I'm trying to validate entries in a classic sharepoint calendar, let's name it Cal1.
Explanation of the superseding problem:
People enter dates in the calendar. Calendar entries resemble planned ...
0
votes
0answers
22 views
Collect date+hour on every status change
Is there a way to write date and hour on a column on every status change in sharepoint?
Example:
STATUS A -> write date+hour on column A
STATUS B -> write date+hour on column B
STATUS C -> ...
0
votes
1answer
17 views
SharePoint time difference in minutes - wrong result
I created a simple SharePoint list and I am having problem with a calculated field.
I have a "Duration" field that calculates the minutes between the start and end date/time columns, using the formula:...
0
votes
1answer
29 views
Created Date is incorrect in SharePoint List
I am not sure why this is happening and is there a way to rectify it. The date in the created column of my list is showing as 2018. This list or the site did not exist back in 2018 then how come the ...
1
vote
2answers
19 views
Using DATEIF only if another column returns 2 out of the 3 column entries
I'm attempting to calculate the difference in dates (the current date & Date Opened column) only if the Status? Column reads Open or Hold.
I've tried:
=IF(Status?,"Open" OR "Hold",(DATEDIF([Date ...
1
vote
1answer
19 views
How to hide or show field based on an entry into date field in Powerapps
In PowerApps custom form I'm looking to hide field B when entry is made into date field A.
I've found plenty of examples for yes/no or dropdown but none for date field.
Thanks, RN
0
votes
1answer
17 views
Calculating difference between two date picker fields in number of days in infopath
I am trying to calculate the difference between two date picker fields which should result the value in number of days in infopath.
I tried number(substring(field1, 9, 2)) - number(substring(field2, ...
0
votes
1answer
14 views
Date must be more than 2 Years from today
I have a date column in a SharePoint list. This column need to be filled with dates that 2 years forward from today or more.
How can I write the validation formula for this?
Much appreciated if ...
0
votes
1answer
19 views
Workflow: when adding minutes to a date… what's the default time?
I have a workflow for sending notifications 63 minutes after a given date. I'm reading the date field and adding 63 minutes.
The date field doesn't have a time (it's configured as "date only"), so I ...
0
votes
1answer
19 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
32 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
55 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
141 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
35 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
54 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
23 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
44 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
44 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
81 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
39 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
194 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
30 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
62 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
92 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
104 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
30 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
320 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
190 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
11 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
255 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
506 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
73 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
323 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
34 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
51 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
36 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 ?
2
votes
0answers
47 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
53 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
1k 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
180 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
172 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
67 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
82 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/...
