Questions tagged [date-time]
Represents an instant in time, typically expressed as a date and time of day.
485
questions
0
votes
1answer
22 views
Caml Query | How to copy today's list items from one SharePoint online list to another in batches?
I am trying to write a Caml Query to get only today's list items and then later copy it into the new list.
I am using the batch method to copy data from source list to destination.
source list gets ...
1
vote
3answers
55 views
Conditional Formatting ( Color Coding) a date field
I am using the JSON Script below to create a list where records with Expiration date 10 days from @now will highlight RED; 20 Days from @ now will Highlight Yellow, and 60 Days From @ now will ...
0
votes
1answer
66 views
Sharepoint list: How can I calculate difference between two dates without Fridays and Saturdays
I need a formula that can calculate difference between 2 dates without calculating Fridays and Saturdays.
I need to use this formula to create a calculated column in list.
Thank you
0
votes
1answer
10 views
SP2013: Form ideas for picking multiple non-consecutive dates
Hi:I have a "building access request" list on which an employee requests access to our building for the months ahead. One requirement is to allow users to enter multiple dates, even non-...
0
votes
1answer
82 views
SharePoint conditional formatting rule only available for date, how to include time in the rule?
I'm new to SharePoint. I have a SP list for my schedule. I have overdue column that I would like to change background color based on Datetime column and status. The two column are Deadline and Status. ...
1
vote
1answer
66 views
color formatting a date column
I'm very new at list formatting. I've created a new list and are trying to get the columns to turn red/green/yellow depending on the date that you put in to the date-column.
I want the column to turn:
...
0
votes
1answer
21 views
List Date/Time column only shows times as “12:00”
I have a list that has a date/time field, which is set to display date and time (not Date Only). However, whenever times are captured in this field, the time always shows "12:00". Is there ...
2
votes
1answer
42 views
why returned date from version history is different from actual date (triggerbody)
It seems the SP data repository and front-end SP list use two different timezones. when I get a date from version history it is different from what is actually shown in the SP list, how can I fix this?...
0
votes
1answer
24 views
Calculate the difference between two dates in hours and minutes
In SP online in a list, I have a formula that calculates the difference between two dates and outputs the result in Days+Hours+Min.
I was wondering if it's possible to obtain the results only in Hours ...
0
votes
1answer
37 views
Calculating business days between dates and allowing a negative number
I have some working code that calculates business days between two dates:
=(DATEDIF([Date Submitted],[Start Date],"D"))-INT(DATEDIF([Date Submitted],[Start Date],"D")/7)*2-IF(...
0
votes
2answers
27 views
Calculated Filed
I have created a calculated filed to convert a date field to another format, the issue I have is the calculated filed populate data for empty fields as well. Is there anyway it can only populate data ...
1
vote
2answers
26 views
Date Column Validation - Check if Date is less than 10 days from Today
I have created a column named Departure Schedule and its type is `Date and Time.
However, I need to check that the Departure Schedule should not be less than 10 days from Today().
Is it possible to ...
0
votes
1answer
41 views
Calculated Column with TODAY() issue
Using the following:
"If Authorization Date is null, calculate the difference between Receive Date and today; If Authorization Date is not null, calculate the difference between Receive Date and ...
0
votes
2answers
263 views
Capture static date & time when list item “status” column changed to “6-Completed”
Using a Sharepoint List to capture issues and tasks and need to be able to determine how long each item has spent in a specific "status".
"Status" column has choices as below;
1-...
0
votes
1answer
37 views
Minus 5 hours 30 minutes from a date
I have a column of type as date and time. I want to minus 5 hours 30 minutes to produce a new time in a new column - Please advise?
1
vote
1answer
15 views
How do I write validation statement to require a day of the week?
I have a field in a custom list called "WeekOf". I have a default statement that populates the date as the following Monday, but some people are entering for future weeks and then add a ...
0
votes
5answers
43 views
Sharepoint Calculated Compliance Column
I have an SharePoint list with columns:
Title (Single Line Text column)
DteofAwrd and CurrentDte (both date columns)
ComplianceStatus (calculated column)
I am using the below to determine compliance ...
1
vote
1answer
35 views
Sharepoint Designer 2013 Workflow with two conditions including variable
I have two SharePoint list - One is funnel and other is decision register.
If certain condition is met in Funnel for that item, it will be moved to other list Decision Register.
I have following ...
1
vote
3answers
223 views
SharePoint column formatting with json for date fields
I am trying to set custom formatting for date field and followed the guide here: https://docs.microsoft.com/en-us/sharepoint/dev/declarative-customization/column-formatting#apply-conditional-...
1
vote
1answer
29 views
Calculated Date Difference Question
Before submitting this question, I've tried researching this in the forums and have attempted multiple variations of suggested formulas with no success. So apologies in advance for asking what seems ...
0
votes
2answers
24 views
Simple If-Then-Else formating SharePoint list (json)
The code below I want use to change color of the column Date according to the current date.
But instead it gives me a error. Can somebody give me a hint?
{
"$schema": "https://...
1
vote
1answer
47 views
Calculated Column - Days Difference - Syntax Error
I have a SharePoint List and I'd like to have a column to calculate the days it take to solve a ticket (Solution date - Submission Date).
I tried to create a calculated column, by using a formula = ...
0
votes
2answers
153 views
MS Flow: ticks function behaves different if fed with a string than with a string variable containing the same string
Addendum/Preface
I tried a lot to process a date in the form yyyy-MM-dd coming from two columns of a custom list. I read dozens of articles about dealing with dates in flows and processing SP lists ...
0
votes
0answers
22 views
How to compare dates using Flow properly / Date validation in calendars
I'm trying to validate entries in a classic sharepoint calendar, let's name it Cal1.
Explanation of the superseding problem:
People enter dates in the calendar. Calendar entries resemble planned ...
0
votes
0answers
24 views
Collect date+hour on every status change
Is there a way to write date and hour on a column on every status change in sharepoint?
Example:
STATUS A -> write date+hour on column A
STATUS B -> write date+hour on column B
STATUS C -> ...
0
votes
1answer
21 views
SharePoint time difference in minutes - wrong result
I created a simple SharePoint list and I am having problem with a calculated field.
I have a "Duration" field that calculates the minutes between the start and end date/time columns, using the formula:...
0
votes
1answer
73 views
Created Date is incorrect in SharePoint List
I am not sure why this is happening and is there a way to rectify it. The date in the created column of my list is showing as 2018. This list or the site did not exist back in 2018 then how come the ...
1
vote
2answers
20 views
Using DATEIF only if another column returns 2 out of the 3 column entries
I'm attempting to calculate the difference in dates (the current date & Date Opened column) only if the Status? Column reads Open or Hold.
I've tried:
=IF(Status?,"Open" OR "Hold",(DATEDIF([Date ...
1
vote
1answer
96 views
How to hide or show field based on an entry into date field in Powerapps
In PowerApps custom form I'm looking to hide field B when entry is made into date field A.
I've found plenty of examples for yes/no or dropdown but none for date field.
Thanks, RN
0
votes
1answer
65 views
Calculating difference between two date picker fields in number of days in infopath
I am trying to calculate the difference between two date picker fields which should result the value in number of days in infopath.
I tried number(substring(field1, 9, 2)) - number(substring(field2, ...
0
votes
1answer
20 views
Date must be more than 2 Years from today
I have a date column in a SharePoint list. This column need to be filled with dates that 2 years forward from today or more.
How can I write the validation formula for this?
Much appreciated if ...
0
votes
1answer
21 views
Workflow: when adding minutes to a date… what's the default time?
I have a workflow for sending notifications 63 minutes after a given date. I'm reading the date field and adding 63 minutes.
The date field doesn't have a time (it's configured as "date only"), so I ...
0
votes
1answer
23 views
Filtering by date isn't working properly
I have some struggle viewing lists with a Group By.
The list contains documents that belong to a certain event. Therefore, we added a lookup field which points to the date + start time from the ...
1
vote
1answer
52 views
Workflow Date/Time variable is off by 4 hours
I am using SharePoint Designer 2013 to write a workflow on SharePoint 2010.
My time zone is UTC-05:00 and that is the time zone in my site's regional settings. I have a list that has a look up from a ...
2
votes
2answers
34 views
DATEDIF Calculation losing a minute
I have a timesheet for users to enter Start Time, End Time and Breaks. I've created this calculation to total the number of minutes worked. However, sometimes it loses a minute. How do I fix this ?
...
1
vote
1answer
23 views
multivalidation in sharepoint list [closed]
I am working on sharepoint 2016 and having issue in applying multiple validation between date column
Column A should not be less then Column B
Column F should not be less than Column C
Column E ...
4
votes
2answers
68 views
Calculated column to show status if another has a value
I have a SharePoint list with a completed date column. I wish to have a calculated column called status so when the completed date column has a date in it, it shows "Closed" and when it is blank it ...
2
votes
1answer
358 views
How to use - SPUtility.GetSPField to set date
The script does not work. I have to write the date value in the field (I tried to do both a regular text field and a Date field) Date2 As it seems to me because of the wrong name. But maybe something ...
2
votes
1answer
50 views
SharePoint color formating
I have a Date column in the list and it represents Expiry date.
I need the field to be colored red if the date has passed, orange if the expiry date is less than 30 days, green if the date is more ...
1
vote
1answer
69 views
Date Difference in minutes SP Calculated Column
I have a SharePoint Calculated column that is supposed to calculate the difference in hours and minutes between two dates.
This is the expression I am using for that:
=TEXT([IN/OUT Time]-[Staging ...
0
votes
1answer
29 views
Date is correct, but String is not being recognized as a valid datetime
I use this to get the current date with one month added to it:
var date = new Date();
day = date.getDate();
month = date.getMonth() + 1;
month = month + 1;
if((String(day)).length == 1)
day = '0' ...
0
votes
2answers
117 views
Display a date field in a specific format as single line of text using calculated column
I Need the Right Formula for the following Problem:
I got a column that contains only date but sometimes it contains no Information.
=DAY([AB])&"."&MONTH([AB])&"."&YEAR([AB])
This ...
1
vote
1answer
85 views
If calculated value column exceeds 24 hours
I got this calculated column that shows values of "hh:mm:ss". But i've noticed that if its exceeds 24:00:00 it will restarts to ex. 01:00:00..
Is there any way to make a validation or format the ...
1
vote
1answer
57 views
Calculating Fiscal Month
I've seen a number of calculations for fiscal year and quarter, but am hoping someone can help me a calculated column for fiscal months. Our company's fiscal months run from the 29th through the 28th....
0
votes
2answers
434 views
Calculated Column Field Date
I need to calculate date based on other column
I'm using =Date(Year([endDate]),1,1) in a calculated field which needs to return data as DateTime, but it is giving me error:
The formula contains a ...
0
votes
1answer
66 views
How can I make a field visible depending on the content of another field?
I have a PowerApp which is working really well so far, it is based on a SharePoint list which holds the data. There is a date field (Paid Date) which defaults to 31/12/2001 for some reason, and I want ...
0
votes
1answer
101 views
SharePoint 2013 Get difference between two dates in days using JavaScript/J query
I want to get the difference in days between two dates. One date is from a List item input by User. The second day will be "Today". get the number of days from the date input by user and current day.
...
0
votes
1answer
128 views
Calculating “Task Aging” without weekends
I am calculating the number of days a task is aging.
This works great:
=DATEVALUE(TEXT(NOW(),"mm/dd/yyyy")) - DATEVALUE(TEXT([Created],"mm/dd/yyyy"))
However, I need the counting to STOP when the ...
0
votes
2answers
25 views
Calendar Appointment View
Am looking for some help please with how to amend a calendar i've created to show Public Holidays so it shows the title only for an appointment and excludes the start and finish times.
Thanks for any ...
1
vote
3answers
185 views
SharePoint 2013 calculated column -compare dates
I thought this is easy but somehow I didn't get this right.
I entered the following formula in the calculated column but the outcome is incorrect.
For example, when [Target_Finish]=10/10/2019, the ...
