Questions tagged [date-time]
Represents an instant in time, typically expressed as a date and time of day.
449
questions
0
votes
1answer
12 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
25 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
23 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
10 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
65 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
22 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
55 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
22 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
26 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
49 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
23 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
39 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
27 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
57 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
47 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
146 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
133 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
50 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
29 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
136 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
30 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
35 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
23 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
41 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
42 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/...
0
votes
1answer
341 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
51 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
71 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
42 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
58 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
61 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
48 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
30 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
35 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
40 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
28 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
13 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
63 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
33 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
284 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
516 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
306 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
182 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
vote
1answer
34 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
1answer
58 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
50 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
383 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 ...
