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
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 ...
serge's user avatar
  • 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 ...
Chris's user avatar
  • 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 ...
laurunger's user avatar
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 ...
Egor Emelianov's user avatar
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 &...
laxmi priya boina's user avatar
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 ...
badsalvarado's user avatar
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” -...
Sara Lons's user avatar
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 ...
user1903995's user avatar
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'...
Brax's user avatar
  • 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")...
Mark Wadsworth's user avatar
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 ...
Delli's user avatar
  • 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 ...
David Stubbs's user avatar
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 ...
Random206's user avatar
  • 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 ...
Lukáš Toman's user avatar
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 ...
erron522's user avatar
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
microsoftdeveloperdesigner's user avatar
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 ...
erron522's user avatar
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, ...
mklaaco13's user avatar
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 ...
learning_sp_guest123's user avatar
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),...
Gen_C's user avatar
  • 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 ...
Jonnyboi's user avatar
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 ...
Yunus Emre's user avatar
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 ...
LisaMayr's user avatar
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 ...
Andrew15's user avatar
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 ...
LostInSharepoint's user avatar
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 ...
BeerusDev's user avatar
  • 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 - ...
VASoftball5's user avatar
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 '...
dataKim's user avatar
  • 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 ...
Zakir HC's user avatar
  • 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&...
Gonzalo Andrs Saravia Hernndez's user avatar
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 ...
FrankieV's user avatar
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], " ", (...
Basharathullah Mohammed's user avatar
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 ...
Harris's user avatar
  • 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-...
Rothrock's user avatar
  • 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 ...
Mathieu-Alex's user avatar
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 ...
Shannon Kearney's user avatar
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: ...
Douglas Shultz's user avatar
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 ...
jim's user avatar
  • 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 ...
Billy Whitley's user avatar
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) ...
Carrie Wong's user avatar
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])...
Adam Graham's user avatar
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 ...
BeerusDev's user avatar
  • 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 ...
Arul Selvan's user avatar
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 ...
Shreya's user avatar
  • 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 ...
BeerusDev's user avatar
  • 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 ...
Mirjam Kaal's user avatar
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 ...
user1063287's user avatar
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, ...
Rohit Waghela's user avatar
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 ...
user2925436's user avatar
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 ...
harshal gite's user avatar
  • 1,474

1
2 3 4 5
11