Questions tagged [date]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
0
votes
1answer
16 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
0answers
8 views

Validation expression between two dates

I have two columns to support Out of Office request (MS Flow). I would like to create a formula to validate a situation like this: 1) START DATE cannot be lower then today (formula cannot allow the ...
0
votes
1answer
16 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
0answers
18 views

Calculate Business Days

I've been using a calculated column with some IF statements to calculate the number of business days between 2 dates. =IF(ISERROR(DATEDIF(Created,Today(),"d")),"",(DATEDIF(Created,Today(),"d"))+1-INT(...
0
votes
1answer
30 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
0answers
8 views

How to change Last Modified for a linked document

In a Sharepoint list I have a linked ppt file. How can I see the modified date of the linked file (ppt) not the modified date of the list?
0
votes
2answers
37 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
25 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
35 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
47 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
0answers
12 views

Get no data when querying with date in caml query sharepoint

When I am trying to query on any date field I am not able to get any data even with caml query: <Where> <Eq> <FieldRef Name='date' /> <Value IncludeTimeValue='...
0
votes
1answer
35 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
0answers
26 views

SharePoint 2019 - blog's published date doesn't update (1899)

I have done a migration to our company's SharePoint from 2013 to 2019. Everything is working as intended except blog posts date function. At the moment whatever I do the publishing date seems to be ...
0
votes
1answer
18 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 ...
0
votes
0answers
10 views

Date and Time formulas

If you put in a formula for a date and time to calculate a difference, but only one of the fields has an answer - it returns a huge number rather than 0 - so when needing to tally average difference ...
1
vote
2answers
174 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
33 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. ...
1
vote
1answer
55 views

Problem with date range filter

I have implemented date range filter on my SharePoint 2016 list using date filter web part. The complete procedure you can find here But after this implementation my list search box vanished. Even ...
1
vote
1answer
11 views

Date caulculation based on result of drop down column

I am trying to assign a due date based on the outcome of a column. I have a drop down on a list with the choice Complaint or No Complaint called Related to Complaint? I am trying to set a due date ...
0
votes
1answer
67 views

How to change date display

Currently the below code gives me a date display of: 2019-01-31 00:00:00. I would like to see it displayed as: 31 January 2019 instead... <table width="35%" align="left" id="myHTMLTable" border=...
0
votes
1answer
13 views

Populate a date field based on text fields being updated

I am supporting a team with the SharePoint site that is used to request tasks to be completed. When the "Item ID"(Single Line of text) field is populated we want the "Date Item ID Generated"(Date ...
0
votes
1answer
30 views

Date Created And Date Closed Field showing #NUM whilst still open

I am using Microsoft sharepoint. I have 3 fields: - Date Created - Date Closed - Duration I am trying to work out how to get the duration column to populate whilst the date created field has been ...
0
votes
1answer
86 views

CAML Query to find items with wrong expiry date

I have a library with 65,000 items and for some items the “expiry date“ is not right. The field should actually be calculated automatically from the “creation date“ + 8 years. How can I determine the ...
0
votes
2answers
22 views

Transform data into a date in a list and make it functional

I am having issues trying to transform data into a functioning date in SharePoint Online in a list. The idea is that we display upcoming birthdays for the company but don't display their actual age. ...
0
votes
2answers
50 views

Calucalted colum in list on SharePoint 2010

Hope you're well; Can I have help with the following SharePoint list, I would like the expiry alert date column to automatically update to 6 months post the contract expiry date column; Is possible ...
1
vote
2answers
67 views

Difference Between 2 Dates (number of hours beyond 24 hours)

Trying to get some working syntax for calculating the difference in hours between 2 dates, Start Date [9am] and Due Date [5pm] for example. =TEXT([Due Date]-[Start Date],"h") This yields the correct ...
0
votes
1answer
21 views

Use workflow to automatically create task for insurance renewal invite

I have a list with contains information on insurance policies, such as "type of insurance", Client name, inception date, expiry date, premium as well as "staff responsible column (which contains the ...
0
votes
1answer
25 views

Using Lookup field but removing some items

We're creating a sign up list for our fortnightly inductions at work. We've got a list which has all the induction dates, and another list for the signups. The signups list has a lookup field to the ...
2
votes
1answer
376 views

Workflow to send Reminder Email based on Reminder Date

I am currently dealing with a doubt rather than a problem. I would appreciate it if you could help me out. So i have a workflow in which i pause it until the reminder date and then send an email. I ...
2
votes
0answers
242 views

How to change date format correctly? (1899-Dec-30 error)

I would like to use date format for "Modified" field YYYY-MM-DD instead of the default MM-DD-YYYY. So I created a calculated field with the code: =TEXT(Modified,"yyyy-mmm-dd") But at about 70% of ...
3
votes
1answer
302 views

Follow up based on weekdays

I have a list with a Date Column and a Followup column. If the weekday of the date column is Thursday, the follow up should be on Monday next week. If the date column is Friday, follow up on Tuesday, ...
0
votes
1answer
45 views

How to adds 3 more days to the due date from the current date excluding the weekend

I have a wf running that when a task is rejected, it adds 3 more days to the due date from the current date excluding the weekend. Now I want to exclude any federal holidays. If the due date (today+3 ...
0
votes
1answer
109 views

Date created in formula

I am trying to have a calculated column which to show the year and the month of item creation and a letter in front. I tried the formula : ="R"&RIGHT(YEAR(Created);2)&MONTH(Created) but this ...
0
votes
1answer
738 views

What is the XSLT query to get items which have date greater than or equal today

I haven't worked on XSL. Scenario: We have a list which has a column called expiry. We want to display only those records which have expiry date greater than or equal to today's date. Trials: ...
1
vote
1answer
431 views

Calculate Yearly Quarter

Trying to create a column that will determine the financial quarter that a date field currently represents. The 1st quarter should always begin on November 1st. Current formula: =IF(ISBLANK([Actual ...
0
votes
1answer
114 views

Date and Time - My export table is showing TimeStamp even though “Date Only” selected

My list is showing "24 November, 2017 (without TimeStamp)" The code on my index page is showing date in Numerals (11/24/17 and with TimeStamp) e.g. 2017-11-24 01:00:00 1) How do i remove the ...
1
vote
1answer
191 views

Column Validation for new items only

I have the following in the column validation on a SharePoint 2013 site =[Load Date and Time]>=TODAY() The above works well however I have a flaw in my logic! I want users to be able to change ...
3
votes
1answer
39 views

How to get current time in SharePoint designer 2013

It seems everytime I use "today" I get the current date but always at 12:00 PM
1
vote
1answer
315 views

Filter a list based on two due date columns

We have a list in SharePoint 2013, which we want to filter based on two date columns. The due dates refer to two different tasks. We want to see only elements with due date within the next 7 days og ...
2
votes
2answers
376 views

Get cultural information of user using javascript COM

Dates have a different format by country. In Sharepoint 2013, there is a form with a date field and I need to display this date based on the cultural information of each user. Based on other ...
1
vote
0answers
452 views

Calculated field exclude weekends

I am working on custom list which has startDate field and endDate field. I am using to calculated field to find the duration between those fields. I am trying to exclude the weekends.
1
vote
2answers
6k views

Show year and month only on a Date column

I have a date/time column. How can I show year & month only on this column (entered automatically is preferred) Essentially I am making a full digit out of the year and month and sorting it from ...
0
votes
1answer
51 views

Workflow: To be invoiced “if there´s 35 days between created date and actual date”

I´m looking for a workflow to achieve a field "To be invoiced" Yes or Not depending on the creation date and the actual date. Creation date and actual date are calculated fields as for instance: 03/...
1
vote
1answer
111 views

Calculated Date [Sharepoint Online]

Currently having an issue with a calculated date column when the field is not filled in. Displays the date as December 1899. Current formula is: =TEXT(YEAR([Closed Date]),"00")&"-"&TEXT(...
0
votes
2answers
34 views

SharePoint 2013 Filters

I am trying to create a filter for a calendar of events. In the calendar of events, I am only wanting to show 30 days of events in the view. I have a start date field and a calculated field called ...
1
vote
0answers
35 views

Date range filter in OOTB for SPListview

I am working on a project in SharePoint 2013. Currently I am trying to implement list view filtering using OOTB QueryString parameters. I have found the following params have been working a treat ...
0
votes
1answer
768 views

validate date column with AND and Today()

I want my "Day" column to validate as such: It can only be within 14 days in the past It can only be a past date or current day It can not be before June 21 It can not be not be after August 26. ...
0
votes
2answers
354 views

SharePoint list calculated column - calculate date interval

I need to calculate the interval between two dates in the SharePoint 2013 list calculated column. the reason is that, i will need to set a field value based on the interval, for example, if "Current ...
2
votes
1answer
49 views

Code to calculate the duedate

Problem is to get code, which calculates from invoice date due date. Payment term is 150 net days and due date should be always on 10th day. I know only how to get it like in Excel. print_date is ...
0
votes
1answer
761 views

Calculate 30 days forward, excluding weekends and holidays

One user wants to have a column, which will be a Date 30 days forward, but when if it falls on a weekend or holiday, it has to be after that. For example, today is 11/25, so after 30 days, it will be ...