Questions tagged [date]

A date is a reference to a particular day represented within a calendar system, and consists of year, month and day.

Filter by
Sorted by
Tagged with
0 votes
1 answer
13 views

Trying to use WEEKDAY function to make a column always return a Friday date, based off another date column

So far I have this, anyone know why it isn't working?? Goal is to return the first Friday after the [Est. Stock Date]. =IF(WEEKDAY("[Est. Stock Date]"=1,[Est. Stock Date]+5,IF(WEEKDAY("[...
user avatar
0 votes
1 answer
55 views

JSON Language for over 30 days

Sharepoint List, I have a 'Status' column (Completed, In Progress, Requested, Created) and a Date Received column. I would like to 'Date Received' column to turn the text bold, red, 30 days (...
user avatar
0 votes
0 answers
9 views

Sharepoint Online List - Date values not consistent

Hello, I'm currently working in a Sharepoint project with users all over the globe and we have been having this following issue: The following picture shows the version history of the item someone in ...
user avatar
0 votes
1 answer
30 views

Calculated Column using current year (Today)

I need to create a calculated column that would need to show the years since a document was published. Notice that I'm not saying [Created]. The issue is that I have a document library where our ...
user avatar
  • 508
0 votes
1 answer
37 views

SharePoint Calculated Column - Nested IF with dates and today's date

I have three columns: End_Date, Completion_Date, Status If the Completion date is before the end date then the status is "On Time" If the completion date is after the end date or today's ...
user avatar
1 vote
1 answer
10 views

Calculated Field (Dates)

I have a vendor SharePoint list and am trying to do a calculation between two dates to let me know when the next Review Date is. All Vendors have a start date but they don't have an expiration date. ...
user avatar
1 vote
1 answer
42 views

Why filtering by date still exceeds the list view threshold?

I try to prepare a view for a list containing more than 5k items. When I try to filter it by an equal value in one column via REST API /Items?$filter=Status eq 'Not completed' , it does show a list ...
user avatar
  • 11
0 votes
1 answer
28 views

Condition based on today's date in calcualted field

I have a calculated column inside a solution Table in Power Automate but I need the condition to be check with a value now() - the current date, not a hardcoded value like this. However when I try to ...
user avatar
1 vote
1 answer
69 views

Calculate the week from a date, Jan 1st = week 1

I'm looking for a calculated column formula which will calculate 1st January 2022 as week 1. I'm in Europe, so, like most of the world, my date field 01/01/2022 = 1st January 2022. I would like 1st ...
user avatar
  • 2,329
0 votes
1 answer
35 views

Date and Time Calculation excluding weekends

I want to figure out the amount of time between Quote Start Date and Quote Complete Time in minutes and exclude weekends. I have tried several examples I found online but I always get a syntax error. ...
user avatar
0 votes
2 answers
191 views

How to subtract years from a date in a view filter in SharePoint?

In SP2013 view filters, if I want to subtract say a week from today I can do [Today]-7 which works. But I want to remove 30 years, which is [Today]-10950 however it complains that the date is not in a ...
user avatar
  • 2,140
0 votes
1 answer
432 views

Display publish date on SharePoint page

Is there a way to display the site page publish date on the page itself? We would like to use this feature on the news post pages.
user avatar
0 votes
2 answers
585 views

Power Automate filter by 'Modified' date and update returned items

I have what I thought was going to be a simple scenario to solve: Multiple SharePoint Lists, each with 40 000+ items in it Running queries based on different columns and export to Excel to provide MI ...
user avatar
0 votes
2 answers
36 views

Calculated field column

I am trying to compare two date columns in SharePoint. I need to update the created date field to a different date, but only on documents that have a scan date less than the created date. So I have a ...
user avatar
1 vote
1 answer
499 views

Microsoft Lists - Date formula to exclude weekends

I am using Microsoft Lists for our work schedule and I would like the "Due Date" column to be calculated based off the "Prepare Date" and "Number of Days" columns ...
user avatar
  • 11
0 votes
2 answers
138 views

Auto-Populate Date in Column When Seperate Column Gets Filled

I've checked around a few other questions asked around this, but none have really applied to what I am looking for. Using Sharepoint 2019 Online, we have a sheet that contains 12 different columns. ...
user avatar
0 votes
1 answer
41 views

Validation for 2nd monday from today

I am new to SharePoint and I'm trying to do a validation for greater than or equal to the 2nd Monday from today. I'm creating a work request form and I want to make sure they can't make a due date ...
user avatar
0 votes
1 answer
52 views

How do I require a date from a specific day of the week in my sharepoint form?

I have a form I've created in Sharepoint where I need the requester to enter a date. This I've got set up. I would like to make this field so they have to enter a specific day of the week, in my case, ...
user avatar
0 votes
1 answer
45 views

Display Date from calendar list in Content editor

I have a calendar list that displays outages of various products. ex. Product 1. | 1st Jan. | server down Product 2. | 1st Jan | server down Product 3. | 5th Jan. | maintenance On top of this list ...
user avatar
  • 1
0 votes
1 answer
38 views

Date Calculation for Leave Entitlement

I am trying to calculate leave entitlement based on the date of joining and current date, at antry date the person has 20 days of leave if the person has completed their 2nd year anniversary by 01 ...
user avatar
2 votes
2 answers
123 views

(another take on) Filtering Sharepoint view based on date range

I know that the answer for this question is easy to find on the internet, including this thread - but the suggested solution doesn't work for me. I need to create a view in a Sharepoint online list, ...
user avatar
1 vote
3 answers
11k views

Date format in JSON view formatting

I'm formatting the view of a large list in SharePoint. One of the many columns is a date column. I'm using the following code: { "elmType": "span", "txtContent": "[$...
user avatar
0 votes
1 answer
87 views

properties.ItemEventProperties.AfterProperties["ProjectDateSinged"] will show the date minus one hour

I have the following code inside my remote event receiver inside a SharePoint online team site, the remote event receiver is deployed inside azure web service:- if (i["ProjectDateSinged"] != ...
user avatar
1 vote
2 answers
200 views

Adding days on calculated column from monday to friday

I need to add a calculated column in SharePoint where I have to add +1 day from Monday to Thursday and +3 on Friday but I don't know how to do it. I did some tests with WEEKDAY without success.
user avatar
  • 15
2 votes
2 answers
300 views

Calculated Column: Prevent date from changing - SharePoint 2013 online

Need some help please - currently working on SharePoint 2013 online. I have a choice column (drop down) called 'Stage'. In 'Stage', I have 3 choices; Start Pause End I also have 3 calculated columns ...
user avatar
  • 23
0 votes
1 answer
93 views

Date column grouping header links to page with date format incorrect and no results shown

I have a SharePoint Online list using the Modern view that I have grouped by a date column. When showing the list of groups everything appears fine. However, when I click the group header to view all ...
user avatar
  • 3
0 votes
1 answer
17 views

Convert a column value like "June 11, 2020" into an actual date so I can filter on it relative to TODAY

I want a column to list the upcoming dates for a meeting that I am manually entering into the drop down list. However, I want one of my views to only show the meetings that have passed. I tried to ...
user avatar
  • 11
0 votes
1 answer
38 views

Populate Sharepoint column with the dates of the next 3 Thursdays

I am trying to setup a list that captures signups for a weekly meeting that happens on Thursdays. For each Thursday, there can be up to 4 people signed up on the meeting agenda. I was hoping to find a ...
user avatar
  • 11
0 votes
1 answer
49 views

Calculated date value format is 2020-02-02T22:00:00Z instead of local time format

I'm a beginner with SharePoint so I hope you won't find my question too strange. I am facing a problem that I can't solve alone. Here is the problem: I ha ve made a list with a specific column called ...
user avatar
  • 1
0 votes
1 answer
79 views

Generate a published date for documents in a SharePoint library

I am very new to SharePoint and I want to automate a creation of a published/approved date for documents when they are approved through the OOTB approval workflow to a major version. From what I have ...
user avatar
  • 1
1 vote
1 answer
190 views

How to set date for 2 weeks out for an automated reminder

I have a SharePoint list that is populated with ticket data. There are two primary columns "Open Date" and "Calculated Date" I'm trying to figure out how to set the calculated date 2 weeks out from ...
user avatar
  • 23
1 vote
0 answers
42 views

SP Online modern ui: reformat date in managed property column

Using SP Online, trying to show a friendly format date (without time) in the SPFx modern search results web part. I've mapped the date column to a preset managed property of type date. That displays ...
user avatar
  • 569
0 votes
1 answer
43 views

Sharepoint Online list - display future dd-mm-yyyy

I would like to display the date (dd-mm-yyyy) of the first day of the next quarter in a column (call it Due Date). This would not be calculated based on any other date entry in the Sharepoint ...
user avatar
0 votes
1 answer
169 views

Search by date not working in list search box

So I have a list which contain a date column named my_date. My site's locale in regional setting is set to English (United Kingdom) so date is displayed as DD/MM/YYYY and time zone is UTC + 3 I ran ...
user avatar
  • 3,614
0 votes
2 answers
132 views

Calculated Date Column with Nested IF statements

I am trying to calculate a Date based on two different columns in a SharePoint List: RANK column and PEBD column. Essentially, I need to do the following: IF RANK is E1, then the value of the ...
user avatar
0 votes
1 answer
139 views

Calculated column for date difference taking into account weekends and negatives (Errors #NUM! and #Name?)

I've been fighting this and going around in circles, hopefully someone will be able to help me out. Issue: I am trying to create a calculated column (Text) that compares today's date "Now()" with a ...
user avatar
1 vote
1 answer
47 views

SharePoint file name help

I have a value startOfMonth(addToTime(utcNow(), -1, 'Month')) in Create File action in Microsoft flow. It gets the first date of the month and names the file as 2020-01-01T00_00_00.0000000Z.html. ...
user avatar
  • 151
0 votes
1 answer
150 views

SharePoint Rest API - Get exact dates as being shown in SharePoint list irrespective of current user's timezone

I have a SharePoint list with custom forms, where the items are created from users in various timezones. The dates are getting saved correctly in the SharePoint list, but when the item is viewed ...
user avatar
2 votes
1 answer
934 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 ...
user avatar
  • 21
1 vote
2 answers
51 views

date calculation

do not know if this can be done with SharePoint calculation. what i am trying to do is calculate between two or three dates. i know the formula for calculating between two dates but it is the latter ...
user avatar
0 votes
2 answers
31 views

Response date fucntion

I want to obtain the response date (number of days) based on other parameters. Used to use an excel file for document management, trying to upgrade to sharepoint and use meta-data. The formula i'm ...
user avatar
0 votes
1 answer
32 views

adding years to existing date to produce expiry date ( SP list)

I have a list of training course that all have different levels of validy. So course A lasts for 3 years Course B lasts for 2 years Course C lasts for 1 year At the moment I have a column with ...
user avatar
  • 1
1 vote
1 answer
103 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....
user avatar
  • 11
1 vote
2 answers
99 views

SharePoint Online - Updating dates in Excel

We are encountering strange issue while updating date column in SharePoint online excel files. When the dates are entered using dots in between the date and month( like 21.10 , 18.5),in excel it is ...
user avatar
  • 1,460
0 votes
1 answer
166 views

Date format: How to set date in new/editForm via Javascript in SharePoint 2016

I'll try to set a date field within a SharePoint 2016 new-, or edit form via jQuery. Works fine so far: fieldJqueryObject.find('input[type="text"]').val('08/28/2019') The problem: It works only if ...
user avatar
  • 617
1 vote
1 answer
309 views

change date in infopath form via javascript

I have a sharepoint 2019 site. in this site i create a list with two column (1.name[text type] 2.Date[DateTime Type]). then i design this list in infopath. When I want to add a new item, I change the ...
user avatar
  • 31
0 votes
1 answer
116 views

How do i display the first modified date instead of the Last Modified Date

I want to a column to display when a record is first modified. SharePoint defaults the modified date to the last modified date. My goal is to also have a column when it was first modified so i can ...
user avatar
0 votes
1 answer
97 views

Share Point how calculate days in whole number

I'm using this formula in shapoint to calculate the difference between start date and due date. This formula is working very well, but when the approvals receive the automatic email about the Out of ...
user avatar
0 votes
1 answer
190 views

How to calculate first day of the current month?

SharePoint 2010; Workflow; Need to create a date variable which should be populated with the first day of the current month. Is it possible? I tried calculate date (no luck) because you have to ...
user avatar
0 votes
2 answers
74 views

Formula to get Current date when a change is made

I have a simple SharePoint item list . Consider this specific spreadsheet for an example, but I need an general solution to work as a Excel formula. A1: contains a date. B1:Status contains a status ...
user avatar