Stack Exchange Network

Stack Exchange network consists of 174 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.

1
vote
1answer
24 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
24 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
9 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
41 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
12 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
21 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
38 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
21 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
48 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
51 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
17 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
23 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
33 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
206 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
157 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
134 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
40 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
41 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
428 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
329 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
84 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
116 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
33 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
222 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
308 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
359 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
4k 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
48 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
96 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
28 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
467 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
273 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
47 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
480 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 ...
0
votes
3answers
597 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 ...
1
vote
3answers
96 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 ...
8
votes
1answer
4k views

Filter “Modified” by previous week

Want to filter list items that were modified on last week Think pseudocode for this will be Modified >= ( [Today]-WEEKDAY-7 ) && Modified <= ( [Today]-WEEKDAY ) No matter what day of ...
0
votes
1answer
311 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
1answer
471 views

SharePoint list conditional formatting - US versus UK dates

I've tried my best not to ask for help, but I'm stuck, even after I learned a bit of JS, MomentJS and Client Side Rendering on SP. The code below returns undefined in date column. If you know why, ...
0
votes
1answer
230 views

SharePoint workflow: Due date reminders

I have a form that takes 2 dates- a. Assigned due date & b. Adjusted due date. now, I wish to check that if "adjusted due date" is non empty then use it for reminder mail else use "assigned due ...
2
votes
1answer
73 views

Column Validation Preventing Me From Copying/Updating List Items (PowerShell)

There is a date list column I'm having trouble updating since there is a validation formula linked to it. =(TEXT([Week Ending],"dddd")="Saturday") The date that gets inputted for the Week Ending ...
0
votes
1answer
29 views

Filter a document library for distinct file names with file date >= Prior Month end

File List: 20170320_My FileName.pdf 20170320_Another FileName.pdf 20170313_My FileName.pdf 20170313_Another FileName.pdf 20170306_My FileName.pdf 20170306_Another FileName.pdf 20170228_My FileName.pdf ...
1
vote
2answers
64 views

Column calculated to return the year of another column

I have a list that has a column calculated based on another column. [Reference Month] > option type (JAN/15, FEV/15, MAR/15, ..., JAN/16, FEV/16, MAR/16, ..., JAN/17, FEV/17, MAR/17, ...) [Reference ...
1
vote
2answers
666 views

Display Created Date of Document using Content Query webpart

I'm using a Web Part to display a list of filtered pdfs on a page. Managed to get the document name to list without a hitch, but can't find a way to add the date the pdf was added to Sharepoint. For ...
-1
votes
1answer
176 views

Monthly Quarterly Date Calculation in workflow

I have the following requirement to be implemented using designer workflow. Custom List will have a column with value "Quarterly" or "Monthly" Based on the "Quarterly" or "Monthly" value, on the last ...
3
votes
1answer
91 views

SharePoint hosted-add in save date object in list

What is the best way to save date object in SPO list with JSOM? because date where is saved is not correct This is my code(experiments) //This is my date string where i get from datepiker - **25/01/...
0
votes
1answer
3k views

How to create View for 30+ days after column date

I have two columns, a site complete column and a report complete column. I need a view to show all blanks in the report complete column if today is 30+ days past the site complete date. Everything I ...
1
vote
2answers
1k views

Formatting date inside a If than statement

I am struggling to find an answer on how to format a If then statement in SharePoint 2013 using a calculated column. I need to display the word "Completed" if the date =1/1/1900 or display the date ...
0
votes
1answer
31 views

Is any of my data within a date range in February?

I am trying to see if a particular date range has any values in February. I tried using a range in an IF statement with 2 conditions (see below). I am getting a syntax error. Here is what I'm trying: ...