Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [date]

The tag has no usage guidance.

0
votes
2answers
29 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
19 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
32 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
30 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
32 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
19 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
17 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
1answer
800 views

Update a column in SharePoint 2013 with the current date on a daily basis

I am trying to update the date in a column to show Today's date and automatically update it every day in SharePoint 2013. Can someone help? How to achieve this? A front-end or client-side approach ...
0
votes
0answers
7 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
83 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
29 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
0answers
38 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
58 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
28 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
56 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 ...
0
votes
2answers
58 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
19 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 ...
0
votes
0answers
36 views

How can add offset day skipping week end with caml query?

How can I add a number of days to date value but skipping weekends and other holidays coming? Example: (Thursday + 3 => tuesday)
2
votes
1answer
322 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
206 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
246 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
43 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
85 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
590 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
3answers
7k views

How to Format Today's date as mm-dd-yyyy in InfoPath 2010

I have a 2010 InfoPath form with 2 controls. I have a dropdown control called Colors with values Red, Yellow and Green. Lastly I have TextBox control called TaskComplete below: I then created an ...
1
vote
1answer
387 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 ...
1
vote
1answer
162 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 ...
0
votes
1answer
102 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 ...
3
votes
1answer
36 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
271 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
340 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
418 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
5k 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
50 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
102 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 ...
0
votes
1answer
658 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 ...
1
vote
0answers
31 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
656 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
320 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
3answers
702 views

Format date in SharePoint 2013

I have a date field in SharePoint 2013 list. Using SP Service am retrieving the date field value. The value is retrieved as 2017-5-24 00:00:00. I want to format the date as May 5 2017. Can this be ...
0
votes
1answer
366 views

Display current Julian Date in web part

Is it possible to display the current 4 digit Julian date (YDDD) at the top of a column above a web part? I've been trying to google and insert a javascript code in the modify HTML portion when ...
1
vote
3answers
103 views

Query to display multiple months based on start/end date

I am looking for the query for a calculated value based on start and end dates to display month, multiple months spanned. For example.... Start date: 01/01/17 End date: 04/15/17 Calculated Value ...