Skip to main content
Share Your Experience: Take the 2024 Developer Survey

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
9 views

I need to calculate the week number of a specific date

I need to calculate the week of a specific date. This is not working for me: =WEEKNUM([Target Date],1)
Carolina Messias's user avatar
1 vote
1 answer
30 views

SharePoint List - Extract Year & Quarter from Date Field

Wondering how I can have the read-only (calculated columns for Year & Quarter) and show nothing if the date field is blank. Currently I have the formulas for these two columns as: Display Year: =...
Ryan's user avatar
  • 11
1 vote
1 answer
34 views

Date Modified Column not showing full date this year

The date modified column on my SharePoint 2016 on-premises is showing only the day and not the full date for just this year (2024). I have checked other libraries, and this is all over. Has anyone ...
Skean Thu's user avatar
0 votes
0 answers
39 views

Calculating a due date based off date created and priority excluding weekends

I want to create a due date column (calculated column) that is auto-populated using the date created and priority column, while excluding weekends. In my priority column I have the following options: ...
Grace's user avatar
  • 1
0 votes
1 answer
25 views

Error in SharePoint Duration Calculation Formula

I have three columns - a start date/time, an end date/time, and a duration. I found a guide for setting up the duration column to calculate plain text based on the time/date columns, but something in ...
SPgrunt05's user avatar
0 votes
1 answer
29 views

Default Value for Date and Time filed in SharePoint online

Is it possible to set the default value of a date and time field to the Modified date?
Harris's user avatar
  • 595
0 votes
1 answer
80 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
108 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
  • 409
1 vote
1 answer
91 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
14 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
181 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
2k 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
35 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
86 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
79 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
36 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
106 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
73 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
210 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
40 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
3k 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
34 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
70 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
30 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
359 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
2k 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
1 answer
54 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
131 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
91 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
931 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
1k 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
170 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
89 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
  • 595
1 vote
1 answer
2k 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
161 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
226 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
27 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
74 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
458 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
68 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
7k 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
11k 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
1 vote
2 answers
2k 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
98 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

1
2 3 4 5
12