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
2answers
19 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
30 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
62 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
108 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
36 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
31 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
24 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
28 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
27 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 ...
0
votes
0answers
20 views

Sys.CultureInfo.CurrentCulture has wrong info

I am working on SP2016 OnPremise, client side. I used the following function to format my Date objects: SP.DateTimeUtil.SPRelativeDateTime.getRelativeDateTimeString(new Date("2020-01-01") , ...
2
votes
2answers
45 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
4k 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
68 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
58 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.
0
votes
0answers
35 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 ...
2
votes
2answers
142 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
44 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
15 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
30 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
27 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
32 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
105 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
27 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
35 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
42 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
54 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
62 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
28 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
578 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
26 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
15 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
65 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
77 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
111 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
258 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
75 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
73 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
138 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
48 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
97 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
64 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
330 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
75 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
22 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 ...
1
vote
1answer
52 views

Calculated Date formula not updating?

We have a Custom List in SP Online which pertains to parts needing to be inspected. Our list has the following fields: LAST-INSP: a manually entered date showing when the part was last inspected. ...