Questions tagged [date]
A date is a reference to a particular day represented within a calendar system, and consists of year, month and day.
135
questions
0
votes
1
answer
34
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 ...
- 373
0
votes
1
answer
23
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&...
- 373
1
vote
1
answer
44
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, ...
- 13
1
vote
0
answers
17
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/...
- 21
0
votes
1
answer
16
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, ...
- 1
0
votes
1
answer
408
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 ...
- 25
0
votes
1
answer
3k
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 ...
- 373
1
vote
2
answers
735
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 ...
- 13
0
votes
0
answers
35
views
SharePoint calculated column Networking days when (Blank)
I use below code on Share point list to calculate banking days but I want it to show (Blank) when there isn't a date in "End Date List", what do I need to change? Today the code shows a ...
- 1
0
votes
0
answers
18
views
In a Date Column. Default view a calculated "Due Date" based on a date "Start Date" that can be edited with actual "Completed Date"
The columns I want to use are:
"Start Date" and "Event Date"
I want the default value in "Event Date" to show "Start Date"+21 (indicating the "Event" ...
0
votes
1
answer
62
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 ...
- 1
0
votes
0
answers
38
views
Trying to use expressions like [Today]-30 in order to filter sharepoint lists in a date range
I have a SharePoint library that houses monthly invoices, and sorts them by month. The only weird part is that the invoice month goes from the 11th-10th of following month. for example: March ...
1
vote
1
answer
64
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
- 57
0
votes
1
answer
22
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 ...
0
votes
1
answer
124
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 ...
- 5
0
votes
1
answer
20
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("[...
0
votes
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 (...
- 1
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 ...
- 518
0
votes
1
answer
829
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 ...
- 1
1
vote
1
answer
22
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. ...
- 11
1
vote
2
answers
525
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 ...
- 11
0
votes
1
answer
237
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 ...
- 11
1
vote
3
answers
1k
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 ...
- 2,371
0
votes
1
answer
478
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
2
answers
683
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 ...
- 2,150
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.
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
...
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 ...
- 3
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 ...
- 21
0
votes
2
answers
489
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
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 ...
- 1
0
votes
1
answer
219
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, ...
Mary Huffer
0
votes
1
answer
70
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 ...
- 1
0
votes
1
answer
458
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 ...
- 63
2
votes
2
answers
258
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, ...
- 25
1
vote
3
answers
20k
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
1
answer
95
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
2
answers
759
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.
- 15
2
votes
2
answers
604
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 ...
- 23
0
votes
1
answer
182
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 ...
- 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 ...
- 11
0
votes
1
answer
53
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 ...
- 11
0
votes
1
answer
199
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 ...
- 1
0
votes
1
answer
140
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
1
vote
1
answer
505
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 ...
- 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 ...
- 589
0
votes
1
answer
61
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 ...
- 1
0
votes
1
answer
402
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 ...
- 3,658
0
votes
2
answers
388
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
1
answer
305
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 ...
- 57