Questions tagged [date-time]

Represents an instant in time, typically expressed as a date and time of day.

Filter by
Sorted by
Tagged with
0 votes
1 answer
31 views

Conditional Duration Column in SharePoint Online

We have a SPO list with a metadata column named Status of type choice that contains the following values: Opened Closed Re-opened We want to create another column called Case Duration that will ...
user avatar
0 votes
0 answers
19 views

Work Day Calculation

I have a field which calculates the number of minutes between two different times and dates. It excludes weekends for me as well. My team is wanting to take this one step further and modify it to only ...
user avatar
0 votes
2 answers
45 views

Date and Time Calculation in Sharepoint Excluding Weekends and displayed in minutes

The code below is working well to calculate the time between two dates and excluding weekends. However, I would like to modify it to just return the number of minutes in number format so I can do some ...
user avatar
0 votes
1 answer
20 views

I want to look at 2 date & time fields and compare that to now to return a status

We have locations that are open or closed for the day. I want to create a list that has a status column that says if that location is open or closed based on two other date and time fields. Example 1: ...
user avatar
0 votes
2 answers
48 views

Using calculated value columns using date

I have a SharePoint list that has the following columns: I'm having a hard time making this. I want to make the Status column a calculated value dependent on departure and return. I want to show if ...
user avatar
  • 1
1 vote
1 answer
24 views

Calculated Column to show only Month and Year from formula results?

As is, the formula below works perfect for my project. However, I would like to spice it up by having the results just display the Month and the Year of the "Next Test Date". Also, is there ...
user avatar
1 vote
1 answer
28 views

SharePoint List - Column Validation

I want to write 2 formula to validate below conditions: I have 3 columns in SharePoint list: Date of Booster (Date field) Is resident in Hospice? (Yes/No Field) Date Admission at Hospice (Date Field) ...
user avatar
1 vote
2 answers
520 views

SharePoint Online List - days between two date columns

I've got a very simple formula to calculate the number of days between two dates which works, with one exception. Formula: =IF(ISBLANK([Completed Date]),"TBC",[Completed Date]-[Created Date])...
user avatar
0 votes
1 answer
85 views

Calculate the difference between current day and date column in years

I have a column StartDate and I want to calculate the time difference in years from that date to the current day. For example: My start date of work is 4/19/2016, it will be 5 years until 4/19/2022 ...
user avatar
  • 131
0 votes
2 answers
117 views

Calculated column difference between two dates considering Today

I have a calculated column to determine the number of days between Introduction call date and Today's date. It works fine as long as the introduction call date is less or equal to Today's date but ...
user avatar
0 votes
0 answers
27 views

Trying to upload the date type from excel to SharePoint list column

I am trying to upload date column value in SharePoint list column of "date and time" type. The below image of excel data: The "Date of Commissioning" value upload in SharePoint ...
user avatar
  • 45
1 vote
1 answer
141 views

Calculated Column Based off of a Date & Time Field

I have a field called "Onboarding Date" which is a Date & Time field. I want to create a new field called "RetentionDate" which will be a date 1 year later than the users input ...
user avatar
  • 131
0 votes
1 answer
428 views

Update item in a SharePoint list from another SharePoint list

I have two SharePoint lists: List A and List B. Both lists have a column with a special number called VHE (text column) and a column Date. The Date column in List B is still empty and I would like to ...
user avatar
0 votes
1 answer
894 views

What format does the 'Base Time' field in the 'Convert time zone' action expect?

I am successfully converting: 12/25/2021 09:00:00 AM (Brisbane Time) to UTC time, output in the [u] format, ie: 2021-12-24 23:00:00Z using the Convert time zone action. Question You can see that ...
user avatar
0 votes
0 answers
196 views

What is the best way to define dates to use in an .ics file in Power Automate?

Desired Behaviour Create and send an .ics file via Power Automate, where the .ics file looks something like this: BEGIN:VCALENDAR VERSION:2.0 BEGIN:VEVENT URL:https://www.google.com DTSTART:...
user avatar
0 votes
1 answer
90 views

Add st, nd, rd and th (ordinal) suffix (e.g. July 20th, 2021) in "Send an email (V2)" action - Power Automate

Is it possible to add suffix (ordinal) in email body of "Send an email (V2)" action in power automate? Expected Date format - "July 20th, 2021". I am trying to add suffix "st, ...
user avatar
0 votes
0 answers
20 views

Calculated date field shows wrong time if hidden on new entry form

I have a question about a problem that has been dragging on for a long time. I use the hide field formulas on the new entry form to hide fields, that user doesn't need to see. Everything works as ...
user avatar
  • 1
0 votes
1 answer
199 views

Calculate Days, Hours and minutes between two different dates and times

I have a SharePoint list with two date columns. I want to create calculated column which gives the number of days, hours and minutes between these two dates. I have looked at all possible threads, but ...
user avatar
0 votes
2 answers
234 views

Modern SharePoint - Date field not getting saved

Facing an issue with the Date fields in Modern SharePoint. When I type in the date or select a date and then change the year (by manually editing in the input box), it does not get saved. It used to ...
user avatar
  • 1,454
0 votes
1 answer
113 views

Change date settings in the Sharepoint Online Admin Centre to DDMMYY

I'd like to change the date format settings for the Sharepoint Admin Centre. Currently the date is displayed using US MMDDYY (which for me is illogical), to the settings used by most of the world, ...
user avatar
  • 2,319
1 vote
2 answers
663 views

How to filter items with a date range using query parameters of Render list data as stream rest api? [closed]

Microsoft Documentation is providing filter operator which takes greater than, less than or equal to but it is working? RenderListDataAsStream URI parameters The documentation says we can use filterOP,...
user avatar
1 vote
2 answers
37 views

Hiding formula on new entry form gives wrong today date

I have a list column with a date field that I hide when a new item is created. =if([$Status]=='Pending', 'false', 'true') The date field is set to default value i.e. "today's date". When I ...
user avatar
  • 11
1 vote
2 answers
30 views

Multiple IF statement in one calculated column

I have tried everything, can someone help me with this? =IF(ISBLANK([Date1]),DATEDIF([Created],[Date2],"d"),IF(NOT(ISBLANK([Date1),DATEDIF([Date1],[Date2],"d")))) It keeps saying ...
user avatar
0 votes
2 answers
189 views

How to determine if date field is empty or not?

I am creating Workflow using SharePoint designer to send the email notification if the date field (revise date) is empty. I just cant find anything to check if the date field is empty? Can you please ...
user avatar
  • 507
0 votes
1 answer
30 views

Create Flow condition: If column "End_date" is less than 7days from column "Start_Date", then

I have two "Date & Time" type columns: Start_date and End_date I would like to create a manual triggered Flow (already have button writen in JSON in place) that compares them and: if ...
user avatar
  • 23
0 votes
2 answers
259 views

Created and Modified Time of ITEM in SharePoint List required in Milliseconds

Is there a way of retrieving the created and modified time in Seconds and Milliseconds? Currently in the SharePoint list it seems it only gives u the dates like this 2021-02-08 17:23. What I need is ...
user avatar
1 vote
0 answers
48 views

Date time column value is off by one hour

SharePoint showing one hour less in UI in one site collection and correct value in another site collection and both site collections/sites having same regional settings and programmatically it is ...
user avatar
1 vote
2 answers
72 views

Calculated column for differences between two column dates with blank check if blank use another column for difference - Sharepoint list

I am trying to create a calculated column which shows the number of days' difference between two columns which have dates in them. I understand that I can get this with the following formula: =DATEDIF(...
user avatar
2 votes
1 answer
110 views

Calculated field for date columns, if date1 has a date use it, else if date2 has a date use it, else use date3

I am working on building a calculated field using 3 date columns on a list and I am having difficulties due to being 3 dates and If/Else. Basically it should calculate a date based on if date1 is not ...
user avatar
1 vote
1 answer
80 views

Calculated column, if box is checked then date+6 month if not date+3 month

I have a SharePoint list with 3 fields: Date: the user enter the info Prolongation: Checkbox Second date: this is a calculated column. This is what I want: if the "prolongation" box is ...
user avatar
0 votes
1 answer
35 views

Sharepoint Restrict duplicate entry in List

Guys Required support for below scenario. I have one list for booking with date and time. I want to restrict the duplicate entry by date and time. I have tried the REST API code but it's not working. ...
user avatar
  • 1
0 votes
1 answer
704 views

Complex Nested If Statement when using Format columns in SharePoint online

I am trying to format a column with a complex nested if statement but the column is ignoring the first if statement and only seeing the second. I have been trying to tweak this, but I can't get it to ...
user avatar
0 votes
1 answer
268 views

List Dates Off by One Day

I am having issues with dates in a SharePoint 2013 list. At a high level I am archiving the dates of the selected item in List1, storing them in List 2. The dates in the selected item are updated to ...
user avatar
  • 75
0 votes
1 answer
101 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 ...
user avatar
1 vote
3 answers
647 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 ...
user avatar
0 votes
1 answer
149 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
user avatar
0 votes
1 answer
21 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-...
user avatar
0 votes
1 answer
223 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. ...
user avatar
1 vote
1 answer
1k 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: ...
user avatar
  • 11
0 votes
1 answer
110 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 ...
user avatar
  • 144
2 votes
1 answer
56 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?...
user avatar
0 votes
1 answer
112 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 ...
user avatar
0 votes
1 answer
96 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(...
user avatar
  • 1
0 votes
2 answers
33 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 ...
user avatar
  • 507
1 vote
2 answers
368 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 ...
user avatar
0 votes
1 answer
124 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 ...
user avatar
0 votes
2 answers
2k 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-...
user avatar
  • 1
0 votes
1 answer
43 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?
user avatar
1 vote
1 answer
69 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 ...
user avatar
  • 11
0 votes
5 answers
62 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 ...
user avatar
  • 13

1
2 3 4 5
11