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.

8
votes
1answer
5k 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 ...
4
votes
2answers
47 views

Can I pull 2 date fields from 1 list into a Calendar view

I have 1 List that has 2 separate date fields that I need to be able to pull into 1 calendar view. How can I do this?? Thanks in advance!
3
votes
1answer
95 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/...
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, ...
3
votes
1answer
257 views

Need help with calculating a date that only falls on a weekday

I have a column named "Date received" and I need to calculate a "Date Due". The due date is 3 calendar days after received however if that falls on a weekend it needs to be the next business day. I'...
3
votes
1answer
417 views

Date Format On SharePoint 2013 Reports

I have Reporting Services reports and Excel Services files published in Sharepoint 2013. The date format of the regional configuration has been changed to Colombia by Date format DD / MM / YYYY. ...
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
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 ...
2
votes
1answer
79 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 ...
2
votes
1answer
258 views

Calculate days remaining with workflow

I'm making a project in sharepoint where I have a list of user id's and a last logon date. The scope of the project is to have sharepoint email a warning when there is 30 days remaining before their ...
2
votes
1answer
294 views

Show date modified of a list in a page

I have a publishing page that has a web part showing a list. I want to show the updated time/date of the list in the page displaying the list. The list contains data that should be updated daily and ...
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
1answer
879 views

Add a Filter for Date Range option in a list

Here is a little background on the task: My client has a sharepoint site that has a list of data. One of the columns or fields is a date field, this date is entered manually using MM/DD/YY Format. ...
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 ...
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 ...
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 ...
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
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 ...
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(...
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
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
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 ...
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 ...
1
vote
2answers
603 views

Site collection last modified date for SharePoint 2007

Hi can someone direct me for best way to generate site list based on last modified date? we have approximately 1500 Site collection in SharePoint 2007. The intention is to remove the unused sites.
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
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
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 ...
1
vote
1answer
546 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, ...
1
vote
2answers
747 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
vote
1answer
254 views

DateDiff in project server

I am using project server, I've tried to subtract start date and finish date in custom field formula using DateDiff to calculate the duration. I noticed the wired output is not identical to the build ...
1
vote
1answer
801 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 ...
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 ...
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 ...
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
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 ...
1
vote
2answers
66 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
1answer
133 views

Date format without spaces

we have migrated Sharepoint from Windows Server 2008 R2 to 2012 R2. Previously was date format without spaces (f.e. 4.1.2017), now it has to be with spaces When I delete spaces, it write text like ...
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
189 views

Unable to handle date change when pausing until date

I need a workflow to assign a task on EndDate. Initially I just tried this with a simple Pause until date, but this cannot handle date changes (the rest of the workflow is not actioned if someone ...
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 ...
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
4k 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 ...
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
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
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
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 ...
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
1answer
29 views

Adding a whole number to a date

I am trying to add the number 7 to the date an item is created in a list, which I want to display as the Due Date. I have tried this formula in the DateDue column =[DateCreated]+[DueDateCalc] ...
0
votes
3answers
54 views

Automatic Date Default

I have a list with a date column, which is updated every month for the 8th business day of the month. I would like that column to change automatically every month to December 8, January 8, etc. ...