Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
23 views

Power Automate Flow - Send an email if a SharePoint 'Proposal Date' Column = the current month

I have a SharePoint list with a proposal date column (SP column name is ProposalDate). I want to manually run a flow that will query the entire list, identify items with a Proposal Date this current ...
Chris's user avatar
  • 409
0 votes
0 answers
3 views

can you use Lists calculated column to calculate dates ignoring specific days, (eg. not counting saturday, sunday.)

Aloha, i am trying to create a calculated column that takes a [start date] and calculate 30 business days forward ignoring saturday and sunday as [expiration date] eg: [start date] - [expiration date] ...
rico's user avatar
  • 1
0 votes
0 answers
13 views

trying to count business days from start date column and give a date 30 business days from start date column

Aloha, I am trying to calculate a running business day counter from [start date] column. Also trying to calculate 30 business days from the same [start date] column.
rico's user avatar
  • 1
0 votes
1 answer
88 views

Power Automate - Update specific List Item in a separate List

I have a strange request that I'm trying to work out, but keep getting stuck on one aspect. So I have a SP Online list with 20 entries - One row per staff member. Each row contains a People column (...
Chris's user avatar
  • 409
0 votes
1 answer
20 views

Calculate column using Month(Today)

I want to calculate month difference from start date - today date using calculate column. I am using this formula: =DATEDIF([Start Date],TODAY(),"M") but I am not getting any result!
Ravi Shirsath's user avatar
0 votes
1 answer
108 views

SharePoint Online Calendar Time entries are off by several hours - Power Automate Flow

I have a SharePoint Online calendar (set to EST in the Regional settings), and an Intake Form that requests vacation, time-off, etc. When this is submitted, then subsequently approved, I have a Power ...
Chris's user avatar
  • 409
0 votes
1 answer
26 views

Reformat the 'Created' SharePoint column to something readable in Power Automate

I have a flow that sends an email to an item's original submitter. In this email I need to display the Item's Created Date AND Time. I'm looking to display something like "11/14/2023 2:40pm&...
Chris's user avatar
  • 409
1 vote
1 answer
78 views

How to filter a list by date > [TODAY]

I have a list for some enterprise events, but I encounter difficulties when attempting to create a view for future events only. The list contains a date_event column which is in the default format, ...
jgran's user avatar
  • 13
1 vote
0 answers
20 views

SharePoint change date format in access request email

The image shown above is a sharepoint user access request approval email we received on the 12th of July 2023. It was approved that day. But it is formatted as mm/dd/yyyy. How do we change it to dd/mm/...
John Doe's user avatar
0 votes
1 answer
17 views

When using List Validation, Add list entry works but not Edit when using Created date

ISSUE: The list validation works when adding a list entry, but when editing the same entry (with no change), the user message is displayed. Using SharePoint 2016. I have tried numerous combinations, ...
UnderMar's user avatar
0 votes
1 answer
534 views

Power automate - Send email reminder on a working day

I have a SharePoint list where I need to send a reminder email 1 day before the due date. I have a scheduled flow that runs from Monday to Friday so that the email only gets sent on work days. My ...
Gen_C's user avatar
  • 25
0 votes
1 answer
5k views

Power Automate flow to send a reminder if Due Date is passed

I'm working on a Power Automate flow based on a SharePoint list. I have a Date column (Due Date) and a Choice column (Status) that I need this flow to look at. Basically what i'm tryign to ...
Chris's user avatar
  • 409
1 vote
2 answers
1k views

Birthday List View

Using Modern SharePoint. I would like to create a SharePoint view that only displays the birthdays that fall within the current month. My list has a name(TEXT) column and birthday(DATE) column. I ...
slugme's user avatar
  • 13
0 votes
1 answer
69 views

Allow for a date to only be used a certain amount of times

We have a date column that we want to only dates to only be used a certain amount of times. I know there's a way to enforce unique values, it this would be 5 entries with the same date and after that ...
ACBM's user avatar
  • 1
1 vote
1 answer
95 views

Date of Editing Column

Is it possible in SharePoint to make it so that when editing a column in another column, the date of editing appears? Preferably by means of the SharePoint itself. Thanks
ruslan88990's user avatar
0 votes
1 answer
31 views

Asterisk on Date Picker DataCard Does Not Disappear when Date Selected in Power Apps

I am trying to hide the 'Submit' button until all required fields are completed. When I set the following formula on the astrisk for the Date Picker DataCard in Power Apps, the asterisk disappears and ...
Aleshia Thompson's user avatar
0 votes
1 answer
139 views

Calculate years of seniority on termination date OR if blank Today's date

I would like a calculation that gives the number of years between 2 dates (Hire Date & Termination Date) but if Termination Date is blank I would like it to use today's date to calculate how many ...
lauri's user avatar
  • 5
0 votes
1 answer
42 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("[...
Jordan Price's user avatar
1 vote
1 answer
1k 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 (...
MTSpace's user avatar
  • 11
0 votes
1 answer
2k 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 ...
cubanGuy's user avatar
  • 518
0 votes
1 answer
940 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 ...
JDaniels's user avatar
1 vote
1 answer
26 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. ...
Grey Lagunas's user avatar
1 vote
2 answers
667 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 ...
Jacek's user avatar
  • 11
0 votes
1 answer
249 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 ...
Simona B.'s user avatar
1 vote
3 answers
2k 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 ...
Tally's user avatar
  • 2,243
0 votes
1 answer
610 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. ...
Shannon Kearney's user avatar
0 votes
2 answers
778 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 ...
omega's user avatar
  • 2,160
0 votes
1 answer
2k 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.
Bart Vandamme's user avatar
0 votes
2 answers
3k 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 ...
user2397081's user avatar
0 votes
2 answers
38 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 ...
Louis Do's user avatar
2 votes
2 answers
2k 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 ...
gd214's user avatar
  • 21
0 votes
2 answers
552 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. ...
user94592's user avatar
0 votes
1 answer
49 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 ...
Tito114's user avatar
0 votes
1 answer
262 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
82 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 ...
SVG's user avatar
  • 1
0 votes
1 answer
661 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 ...
mtagliaferri's user avatar
2 votes
2 answers
272 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, ...
MandMand's user avatar
1 vote
3 answers
22k 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": "[$...
Bart Vandamme's user avatar
0 votes
1 answer
96 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"] != ...
John John's user avatar
1 vote
2 answers
891 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.
MarkR's user avatar
  • 15
2 votes
2 answers
706 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 ...
Jayson's user avatar
  • 23
0 votes
1 answer
192 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 ...
Smith's user avatar
  • 3
0 votes
1 answer
18 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 ...
Mike M's user avatar
  • 11
0 votes
1 answer
60 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 ...
Mike M's user avatar
  • 11
0 votes
1 answer
228 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 ...
Fab's user avatar
  • 1
0 votes
1 answer
169 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 ...
Scott's user avatar
  • 1
1 vote
1 answer
598 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 ...
Ryan's user avatar
  • 23
1 vote
0 answers
60 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 ...
matt's user avatar
  • 589
0 votes
1 answer
70 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 ...
SPC_123's user avatar
0 votes
1 answer
447 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 ...
Frank Martin's user avatar
  • 3,668