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
1
vote
1answer
28 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 ...
0
votes
1answer
22 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. ...
0
votes
0answers
9 views

Search REST api - limit items returned to ones first published in last 6 months

I'm using search REST to get news posts from multiple sites. Is there a way to filter/limit items to just those first published in the last 6 months - similar to the way we can use "greater than ...
0
votes
2answers
69 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 ...
0
votes
1answer
171 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.
0
votes
2answers
255 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 ...
0
votes
2answers
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 ...
0
votes
0answers
25 views

Substract a calculated time from antoher calculated column

I have a SharePoint list in a site as below: Where below are columns: Wer: Person field Zeit_an & Zeit_ab: Date-Field with time included Pause: calculated Column which calculates if its Friday ...
1
vote
1answer
255 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 ...
0
votes
2answers
61 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. ...
0
votes
1answer
34 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 ...
0
votes
1answer
37 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, ...
0
votes
1answer
40 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 ...
0
votes
1answer
29 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 ...
2
votes
2answers
70 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, ...
1
vote
3answers
8k 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": "[$...
0
votes
1answer
75 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"] != ...
1
vote
2answers
109 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.
2
votes
2answers
230 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 ...
0
votes
1answer
63 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 ...
0
votes
1answer
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 ...
0
votes
1answer
36 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 ...
0
votes
1answer
33 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 ...
0
votes
1answer
60 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 ...
1
vote
1answer
144 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 ...
1
vote
0answers
31 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 ...
0
votes
1answer
39 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 ...
0
votes
1answer
81 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 ...
0
votes
2answers
82 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 ...
0
votes
1answer
96 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 ...
1
vote
1answer
42 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. ...
0
votes
1answer
76 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 ...
2
votes
1answer
818 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 ...
1
vote
2answers
48 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 ...
0
votes
2answers
27 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 ...
0
votes
1answer
22 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 ...
1
vote
1answer
92 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....
1
vote
2answers
90 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 ...
0
votes
1answer
154 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 ...
1
vote
1answer
292 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 ...
0
votes
1answer
92 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 ...
0
votes
1answer
85 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 ...
0
votes
1answer
167 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 ...
0
votes
2answers
61 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 ...
1
vote
1answer
110 views

Highlight Due Date Column with color

I am using SharePoint 2016. There is a Submittal library that has been created and one of the users would like the "Due Date" column to highlight in yellow when a document that has been submitted is ...
1
vote
1answer
67 views

Workflow Today function not working properly

i have written a small and simple workflow where in, i am capturing todays date when a status changes. The Column is of Date Datatype(also tried with Single Line Data Type). The workflow is running ...
0
votes
1answer
394 views

When fetching list's items the link of title column is missing

I wrote a spfx web part using sp-pnp-js to fetch items from a list, this is my query to the list: public async getAgreements(): Promise<Agreement[]> { let select = '*'; let Agreements:...
0
votes
1answer
89 views

Formatting A Date Field in SPList

We have a requirement in which a custom date field is displayed in the format: YearMonthDay example: 20181031 How can I achieve this at the Site Column level? Does it require JSON Column ...
0
votes
1answer
23 views

Change date value after confirmation

I got a list where certain items have to be checked yearly. What I am thinking is send to notification email a month prior to due date and when he clicks confirm, the date field should be 2020 ...
1
vote
2answers
2k views

PowerApps Date Only field showing wrong date, but only for certain dates

this is stumping me - I have a canvas app which connects the a SharePoint Online list. In my list, there is a "Date Only" field, which is displayed on the PowerApps form. The formula for Powerapps ...