Questions tagged [date-time]
Represents an instant in time, typically expressed as a date and time of day.
548
questions
0
votes
1
answer
22
views
Extract the date in PowerAutomate
When a user pastes a email (.EML) file in a document library in SharePoint, a Power Automate flow should extract the reception date from that email. In the MIME type, the date is like:
Date: Thu, 2 ...
- 133
0
votes
1
answer
34
views
SharePoint Online Calendar Time entries are off by several hours - Power Automate Flow
I have a SharePoint Online calendar (set to EST in the Regional settings), and an Intake Form that requests vacation, time-off, etc. When this is submitted, then subsequently approved, I have a Power ...
- 373
1
vote
1
answer
33
views
ISBLANK and DATEDIF with two date columns where there are sometimes blanks in both
I am trying to figure out the correct formula for my SharePoint calculated column. I have two date columns [Date in Queue] and [Date Completed]. I need to calculate number of days between the two ...
- 11
0
votes
0
answers
11
views
Search service on DateTime SPPropertyBag field
In short, the question is that: Is there a way (for the sake of knowledge, any way) to tell search crawler about what particular string format of DateTime value is to expect when crawling mapped ...
- 408
1
vote
1
answer
33
views
How to create a calculated column that gives date excluding weekends?
I have a SharePoint list with "Request raised date" and "No. of days" by which the request should be completed.
Now, I want another Date column which adds 'No. of days' to the &...
1
vote
1
answer
672
views
Using IsBlank in formula for Date Time Picker field on Power Apps
Pretty new to SharePoint and Power Apps so would like to ask if what I am trying to do is feasible.
I have a Date Time Picker field in my formula in Power Apps and currently, its default value is set ...
- 23
0
votes
0
answers
20
views
Formula Help Needed: Calculating Dates to Exclude Weekends
I am trying to set up several dates on a list in SharePoint. The dates all relate to each other, and I want to exclude weekends when calculating these dates.
I have three date columns: “Request Date” -...
0
votes
1
answer
43
views
Filter on today's date in sharepoint list doesn't work
I have a SharePoint list with gallery view. In that view I have set a filter.
In my column "Geboortedatum" I have set a date. But my filter which is set to "Geboortedatum" is equal ...
- 109
0
votes
1
answer
37
views
Calculated column Update daily
I have a column that calculates the days until expiration for certifications. To do so I use the Today function:
=[Certification Expiration Date]-TODAY()
I have noticed that this type of column doesn'...
- 25
3
votes
2
answers
33
views
Where am i going wrong with this calculated formula (ISBLANK)?
So on my calculated formula in share point, I can get it to do what I want it to do with the following formula:
=IF(DATEDIF([Start of Absence],NOW(),"d")<28,"No","Yes")...
0
votes
0
answers
9
views
Calculate weekday from 02 date columns (included time) then return value at least 0.5 day
I'm practicing on Sharepoint and have an issue which looking for your guide:
On sharepoint list, how can to calculate 02 [date & time] columns then return value should be at least 0.5 day as ...
- 1
1
vote
1
answer
11
views
Calculated field based upon Date and Time field serves up a weird number
I have a list of learning courses. One column is a Date and Time column showing when a learning course will run.
I wanted to use this column to build a unique course ID. However when I set up another ...
- 11
0
votes
1
answer
72
views
Set SharePoint DateTime field using Calculated Value with todays date but static time
I am trying to create a deployment calendar that sets the default deployment start time to todays date, but always 5PM.
I have looked around and found this previous question (Create a Datetime from ...
- 101
1
vote
1
answer
51
views
Power automate: Calculate date and write to column
I'm solving such a problem and I don't know how to proceed.
I have a list in which the documentation information is stored.
The columns of the list are: Document name, document type (option 1, option ...
- 11
0
votes
2
answers
60
views
Combine 2 columns as 1
Hi I am trying to create a calculated column that lists 2 columns right next to each other as 1. The first column is "Date" and the second column is "Time Zone". I want them ...
- 11
0
votes
1
answer
17
views
Workflow 2013 what does "Add to variable" means
I am redesigning a Workflow 2013 to Power Automate and I have this action inside Workflow 2013:
So what this action do exactly? Thanks
1
vote
2
answers
37
views
Make a column display only when data is in it
I am trying to make a column display only when data is entered in it. If it has no data, then the column should not display on the page. I tried this formula, but it isn't working. I will appreciate ...
- 11
0
votes
0
answers
1k
views
Best way to format null dates when using power automate to transfer excel rows to SharePoint List?
I’m needing a flow to complete these actions:
List all rows from an excel file
Put the values stored in each of the Excel rows and put them in a SharePoint List
If a row is already in the SP list, ...
1
vote
2
answers
25
views
ElseIf options for calculated fields?
I'm trying to calculate a date column based on what data exists in two other date columns. Is that possible?
Basically, in 95% of cases, the Planned Date is always 5 days from the Submission Date. I ...
1
vote
1
answer
55
views
Calculated Date Column IF statement
I have a list in SharePoint on-premises site that has a calculated date column (named Acknowledge Due Date) with this formula:
=IF(WEEKDAY((Created))=1,(Created+3),IF(WEEKDAY((Created))=2,(Created+3),...
- 25
1
vote
1
answer
2k
views
Power automate, copying date column from online excel to SharePoint list
I want to copy date column from an online excel file to a SharePoint list column.
My flow does not update with the date column, it is returning blanks.
Does there need to be formatting to my ...
- 99
0
votes
0
answers
23
views
Sharepoint C# Data Transfer Date Issue
I transfer data from one tenant list to another tenant list with c#. I'm passing the date columns into a string value.
Received data; 3/1/2023 18:00
String value; 3/1/2023 18:00
Value written to the ...
0
votes
1
answer
175
views
How to check for a date/nulls and compare to the current date?
=IF(ISBLANK[Version-created];"";[Version-created]+365)
=IF([Version-created]="";"";[Version-created]+365)
I created these formulas to first detect if there is a date in ...
- 1
1
vote
2
answers
959
views
Combine date and text columns in a new calculated field
Creating a new calculated field in a SharePoint List (Office 365) that combines a text (Region) and a date (StartDate) column. The Region field has a value "DFO" and the StartDate has a ...
- 13
0
votes
0
answers
23
views
SharePoint List Using a Master Date
I am creating a SharePoint Critical Path list with dues dates. I would like the due dates to be calculated using an "Opening Date" - weeks out column.
I am wondering where I can set this ...
0
votes
1
answer
50
views
SharePoint Calculated Column Multi Conditional Formula
I have a Final Submission Due Date calculated column.
I am trying to create a condition to where if another column (Yes/No Boolean) is checked add a certain value, if not use the original value.
I ...
- 113
0
votes
2
answers
104
views
Month and Day functions treating dates as 1 day back
Can any one explain this. I have 3 columns, a date column, month and day columns. The month and day columns are calculated columns of the date column.
DOB - Date/Time (Date only format)
DOB_Month - ...
- 39
1
vote
1
answer
73
views
How to use an IF statement on a Time/Date column to automatically populate a new column?
On my list, I have a Time/Date column named 'ActivityDate'.
The format of this column is "mm/dd/yyyy hh:mm AM/PM"
I am trying to set up a new column called 'Result'.
If the time on '...
- 11
0
votes
1
answer
837
views
SharePoint Date Format Customization
One of our client requirement is to show "DD-MMM-YYYY HH:MM:SS" date format in all the date columns in SharePoint List and custom dashboard (built using SPFx). Using custom code logic we ...
- 3,650
1
vote
1
answer
759
views
SharePoint JSON formatting empty date field with no color
I am using a conditional format for the cells but I want that the empty cells keeps the default color, but with my conditional format the cells with no information are in red color.
{
"$schema&...
0
votes
1
answer
128
views
Display popup notification if date entered in column is less than 21 days
I have a column named Date of Request and its type is Date and Time.
I would like to enable a warning popup message/notification when the user enters a date for a requested maintenance that is less ...
- 1
1
vote
1
answer
26
views
CALCULATED column issue
Scenario:
Need to get difference between two dates (Start Date, End Date) in months, and if End Date is blank, then display "Open".
I am trying:
=IF(AND(ISBLANK[End Date], " ", (...
0
votes
1
answer
84
views
Adding a days to date column
I have a document library with two custom columns (Report Date) and (company name). One company name can have few different Report dates. Is there anyway we can get the highest date using Power ...
- 581
1
vote
1
answer
1k
views
PNPPowershell Add-PNPListItem date columns fail when using -Batch
Trying to take a csv file and import it into an existing SharePoint list. I started with this sample and have made some modifications for our specific case.
The example uses New-PnPBatch and Invoke-...
- 3,010
0
votes
1
answer
139
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 ...
0
votes
2
answers
212
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 ...
0
votes
1
answer
24
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: ...
0
votes
2
answers
73
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 ...
- 1
1
vote
1
answer
336
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 ...
1
vote
1
answer
58
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)
...
- 11
1
vote
2
answers
6k
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])...
- 13
0
votes
1
answer
9k
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 ...
- 113
0
votes
2
answers
1k
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 ...
0
votes
0
answers
96
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 ...
- 55
1
vote
1
answer
3k
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 ...
- 113
0
votes
1
answer
4k
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 ...
- 20
0
votes
1
answer
2k
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 ...
- 214
0
votes
1
answer
640
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, ...
- 2,908
0
votes
1
answer
1k
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 ...
0
votes
2
answers
975
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 ...
- 1,474