Questions tagged [date]

The tag has no usage guidance.

28 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
3
votes
1answer
39 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
0answers
243 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
1answer
35 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
56 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
453 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
36 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
1answer
138 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
0answers
8 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
0answers
19 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
30 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
8 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
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
36 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
26 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
10 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
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
21 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
45 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
51 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
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
404 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
285 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
36 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
288 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 ...
0
votes
2answers
37 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
votes
1answer
215 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 ...