Questions tagged [date-time]

Represents an instant in time, typically expressed as a date and time of day.

Filter by
Sorted by
Tagged with
0
votes
2answers
1k views

Setting End Date to same as start date

I have a list that I created to track start/end times for activities. I'd like to set the form so that when the user enters the start date it populates the end with the same date so that users ONLY ...
3
votes
1answer
1k views

Format Date in Content Query

I have looked through too many threads about this and have made no progress. So far the following links have helped me the most: Content Query WebPart & Date How to format Date in Content ...
3
votes
1answer
818 views

Need help comparing two dates with times

I'm trying to compare two dates with time. I'm able to compare just the date, but when I add the time element it doesn't work. I'm not sure what the correct format should be. <xsl:if test="ddwrt:...
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
1answer
1k views

Time Difference in SP Calculated Column excluding weekends

I have two dates (Initial Date & End Date) both date and time format in a SP List. I need to calculate the amount of days between both of them excluding weekends. I already have the formula in a ...
5
votes
1answer
1k views

SharePoint JSOM datetime values in different timezones

I am working on a solution (on SharePoint Online) which is used by users in different timezones. SharePoint site is configured for "W. Europe Standard Time". Following occurs: A user from US creates ...
2
votes
2answers
2k views

Change Date Format in SharePoint 2016

I want to change the format of date from MM-DD-YYYY to DD-MM-YYYY in list, Gantt charts etc. I have tried one option so far but it doesn't work properly which is explain below: First option: I have ...
5
votes
1answer
2k views

Should SharePoint Alerts automatically adjust for Daylight Savings Time changes?

We have a SP2010 farm that is up to the October CU. After the time change, some users report that alerts that were sending out at 10am are now being sent at 9am. I've googled a fair amount and found ...
0
votes
1answer
2k views

How to calculate Days, Hours and minutes between two different dates and times

I have a Start Date and Time column and a End Date and Time column, I also have a calculated column using a Single Line of Text formula: =TEXT([End Date and Time]-[Start Date and Time],"d:hh:mm"). ...
0
votes
1answer
1k views

Date Column showing “1/1/1900 5:30 AM”

Have created a custom list with below column 1.Title 2.Status (Drop-down column with "In progress" & "Completed") 3.In Progress Time (Date & Time Column) 4.Completed Time (Date & ...
2
votes
5answers
12k views

CAML Query Filtering with OffsetDays

I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this: If a date is not specified on the Query String, then show me items created in the last 30 days If a date is ...
0
votes
1answer
663 views

Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model

I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript. I've tried everything to get those results with query like: "<Where>" + "<...
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 ...
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 ...
0
votes
1answer
734 views

Saving Publishing Page in edit mode returns “Are you sure you want to leave this page?” dialogue

we're getting some ... interesting ... behavior in IE. Setup We have a page layout based on some content type. Both contain (besides other fields) a DateTimeField which is shown in edit mode. When ...
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
1answer
759 views

How to calculate the total days between two selected calendar dates

I've startDate = 7/16/2015 and endDate = 7/20/2015. This 2 dates are stored in a SharePoint list. If user select the exact date with the date in SharePoint list, it can calculate the total days = 2 , ...
0
votes
2answers
56 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
943 views

Show current DateTime as a Survey question

I have a survey list with some questions. I want each survey to have current DateTime. I used DateTime column and set the default value as Today's Date but when i try to respond to survey the column ...
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 ...
1
vote
3answers
2k 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
1answer
899 views

Empty date field goes to 1/1/1900 when updating target list with workflow

Say, I have a SourceList with date fields like these DateReceived, DateEntered. If these field or fields are null then in workflow updates the target list item with 1/1/1900 dates respectively. What'...
0
votes
2answers
1k views

Content Search WebPart: query Date and Time field

I have calendar list, Now trying to query items which is greater than Today. so first I have created new managed property with name EventDate and mapped the crewel property ows_EventDate with type ...
4
votes
3answers
7k views

Field Modified shows date, but no time

In a view of a document library I have the field "Modified" and this is showing only dates but no time. I would like to display the time aswell. From my understanding it is ill advised to alter this ...
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
1k views

Date and time validation

In my SharePoint 2013 I have 4 columns Start Date (date only), Start Time (Single line of text, max 5 characters), End Date (date only) and End Time (Single line of text, max 5 characters). I want to ...
1
vote
1answer
1k views

How to Display Correct Times for Users Regardless of Their Time Zones

I have an InfoPath form on my List. One of the controls on this form is called LoggingTest of type "Multiple lines of text". Below are the settings for this column on my control: The purpose of the ...
1
vote
1answer
997 views

Validating a set of dates in Microsoft Sharepoint

I am trying to validate dates in a task request form that has a column of [Date of Request] (which would be the day that they are adding the task to the main hub. I, then, want that [Date of Request]...
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 ...
1
vote
1answer
1k views

SharePoint Conditional Formatting Date Column

I've been trying to create a Conditional Color column for dates that are expired. The expired dates should be red and the dates that are not should be clear. I tried to use the code from http://www....
3
votes
3answers
3k views

Difference between two dates in hours

In SP list there are two date/time columns, column A and B. I want to calculate difference in hours between those two dates, but only on working hours. My working hours are between 8AM (08:00) and 4PM ...
1
vote
0answers
148 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 ...
0
votes
1answer
1k views

How can I align Date modified with Date last saved?

I still have this problem with Sharepoint 2010 and Windows 7, i.e. Excel or Word documents edited from within Sharepoint display an outdated Date modified in Windows Explorer view. However, the 'Date ...
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 (...
2
votes
2answers
2k 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 ...
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 ...
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 ...
4
votes
3answers
1k views

Date field validation in SharePoint 2007

I need to limit the Date field in a SharePoint 2007 list so the users can enter date from today and up to year after. How can i do it?
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(...
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
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
1k views

Daylight saving time and UTC

Can someone confirm that by using UTC date storage in lists it can cause problems after summer time ends? I'm in the UK and during the summertime I was in UTC+1. So when i saved a date field using ...