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
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 ...
3
votes
1answer
35 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
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
1answer
30 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
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
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
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
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
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
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/...
0
votes
1answer
365 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 ...
0
votes
1answer
255 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 ...
0
votes
1answer
33 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 ...
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: ...
0
votes
1answer
222 views

Default Calendar Date

Currently when users schedule a work shift they are having to select a date on the form. Is there a way to capture the date when they select it from the calendar. You would think that it would already ...
-1
votes
1answer
201 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 ...
2
votes
0answers
204 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 ...
1
vote
0answers
36 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
0answers
414 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 ...
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
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
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 ...
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)