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
1answer
29 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
21 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
19 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
37 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
33 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
8 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
71 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
36 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
24 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
8 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 ...
0
votes
0answers
11 views

Why sharepoint 365 list start and end datetime fields dont set correctly when editing in table view

I have a SharePoint 365 list which includes start and end datetime fields. when I edit the list in table view, if I change the start or end date fields SharePoint saves a different date or time - it ...
1
vote
1answer
31 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
31 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
32 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
127 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
0answers
39 views

Filtering a list by input date between 'start date

I have a MeetingTopic list (things to discuss at a meeting), with a StartDate field and an EndDate field. I am trying to create a page that takes a date parameter (MeetingDate) and presents all topics ...
0
votes
1answer
29 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
15 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
39 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
37 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
69 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
9 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
41 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
54 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
43 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
167 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
44 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
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 ...
1
vote
2answers
622 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
45 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
102 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
12 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
85 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
18 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
43 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
136 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
27 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
57 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
160 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
30 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
27 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
483 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
329 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
454 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
53 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
187 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
1k 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
597 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
157 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
307 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 ...