Questions tagged [date-time]

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

133 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
43 views

DateTime field display diffrent values when editing and when viewing

We have an Office 365 2013 Business Premium subscription and are using Sharepoint online as our Intranet solution. Our problem seems related to DateTimeField and timezone conversion problem The ...
1
vote
0answers
2k views

Workflow - How to convert string to number to date?

I have a string strExpDate and I get the value "130836384000000000" from ldap query. The active directory field is accountExpires. I need to convert this to date/time. The result should be 8/9/2015 7:...
1
vote
1answer
1k views

Validating a set of dates in Microsoft Sharepoint

I am trying to validate dates in a task request form that has a column of [Date of Request] (which would be the day that they are adding the task to the main hub. I, then, want that [Date of Request]...
1
vote
0answers
63 views

Limit Dates available for selection and limit enteries displayed by those dates

I am creating a small timereporting list and would like to have the user select from a list of limited dates. The dates should be all the date for beginning of the week (i.e. 05/04/2015, 05/11/2015, ...
1
vote
0answers
146 views

DataFormWebPart cannot sort item with Last modified properly

In my DataFormWebPart, I have set sort by Modifed column. The column is display with follow format: <xsl:value-of select="ddwrt:FormatDate(string(@Modified), 2057, 5)"/> However, when sorting ...
1
vote
1answer
149 views

Content Organizer creates wrong modified date (2013)

We are using Content Organizer feature to route documents from one site collection to another. We have noticed that upon arriving to the destination documents library, each document has wrong modified ...
1
vote
0answers
272 views

Odata Queries and Date Fields

I have a calculated field that contains the logic if(date) {Yes;} else {No;} This works fine for the column's calculation, but I either need to get the result of the calculated field or need to ...
1
vote
1answer
52 views

Workflow not behaving correctly

I have a work flow that fires off email notifications at specific dates, based on the number of days between the Expiration date and Today. It works up until a user goes to change the date of the list ...
1
vote
0answers
56 views

Calculated Field formula for triggering the task 15 minutes before the starting time

I need to use a calculated field in order to trigger before 15mins of the task starting time. Please let me know what is the formula that I can use for this. Is it something like below? =[Start Time]...
1
vote
1answer
180 views

Timezone question for list items?

I have a sharepoint which is accessed and modified by different people around the world. So when ever a list item is created in the sharepoint the list item modified date should contain that locations ...
1
vote
0answers
21 views

Why does the time-date for document set members differ from the document set time-date after a move

When moving a document set from one library to a Records library via a modified ootb approval SP2010 workflow, the docset has the correct CST date and time, but its document set members are 6 hours ...
1
vote
0answers
224 views

Date and time in SharePoint News Archive List

I have the following method which gets the old news items and displays in the archive page. I am displaying the old news items by month wise. User will click the Month URL and then he can see the ...
1
vote
2answers
95 views

How can i check Today is Equal to DayName in SharePoint Designer Workflow with out any customCode

I have a workflow, it will run on weekly basis, i have to check Today is equal to some DayName. then i hav to send an email. How can i check Today is Equal to DayName, here DayName is String.
1
vote
0answers
197 views

How to make report in SharePoint 2013?

I am trying to make Report of Time registration part in SharePoint 2013. And I try to use Access View but SP 2013 doesn't have Access view or I didn't find out it. If you have any advice or suggestion ...
1
vote
0answers
64 views

Combine 2 seperate date and time columns into one

I have 2 separate columns in a list document library one is date and one is time can they be combined with a calculated column? If so how? Thanks Lewis
1
vote
0answers
625 views

SOAP returns DateTime with timezone offset added to minutes

I am using the Ruby gem 'viewpoint/spws' (from a RHEL 6 server) to insert items into a Sharepoint list via SOAP. It seems that the DateTime fields being passed are being incorrectly interpreted by ...
1
vote
0answers
87 views

Wierd format of Modified date and PublishingStart

Iam having trouble with date formats of these two fields: Modified and PublishingStartDate. They are different in format. Iam attaching how they display on my computer. I have regional settings set to ...
1
vote
1answer
324 views

Trying to implement a follow up date

We have a calendar in sharepoint 2010 Foundation that we have added some extra columns and workflows but I am trying to impliment a followup date. At the moment all we have done is created a ...
1
vote
0answers
326 views

Week number formula for date and time column

What calculated field formula would show me the week number for a date and time like this: 5/27/2012 6:00 AM All the formulas I found are only for dates.
1
vote
0answers
10k views

Set Due Date using a Workflow for a date 2 days after the item was created

Running into trouble using Designer. I need my workflow to set the due date for 2 days in the future but it will only let me set today's date or a specific date as the value.
1
vote
0answers
108 views

Why does Search only accept YMD date format when Search Language is en-ca (usually DMY date format)?

For some reason the server thinks that the date format for English (Canada) is YMD or yyyy/MM/DD, and the server will only correctly read queries with that format. However, the default short date ...
1
vote
1answer
1k views

Daylight saving time and UTC

Can someone confirm that by using UTC date storage in lists it can cause problems after summer time ends? I'm in the UK and during the summertime I was in UTC+1. So when i saved a date field using ...
0
votes
1answer
17 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 ...
0
votes
2answers
36 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 ...
0
votes
0answers
41 views

Search, Dates & Timezones - Can out of the box search on a SharePoint site be made locale aware?

When working with Date columns on a SharePoint list, SharePoint assumes that dates inserted by the users are relative to the current time zone (a sum of the site specific regional settings and any ...
0
votes
0answers
11 views

Creating a Date Column to display in the “Friendly” Format

I'm confused. I have a column "Date Chart Requested" and at first it did display the dates as "5 days ago" which is exactly what I want. But after further tweaking of the custom list, it no longer ...
0
votes
1answer
52 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
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 ...
0
votes
1answer
30 views

Calculated Column Not Displaying Anything

I have this really odd issue that works in 1 document library (first image) and doesn't for another (second image). I have 2 columns, column 1 called Published Date (Flow) that is of type string (...
0
votes
1answer
140 views

Exclude weekends

I am working on a vacation calendar project. I have a custom lists with 2 columns, one being StartDate and the other NumberOfDaysTaken. I am using a simple SharePoint formula (=FromDate + [How many ...
0
votes
0answers
10 views

SharePoint 2013 Convert time pulled by JavaScript to different time zone

I have a text column in a list that receives the value of a JavaScript timer that's attached to a SharePoint survey that populates the column in this format: 2019-08-28T16:56:19.531Z Can I create an ...
0
votes
1answer
31 views

Can I customise the time shown in the datepicker?

I have a scenario where users are to book sessions with date and time. Currently, I am trying two ways to enforce unique values for date and time. I added a date picker. I added a formula to validate ...
0
votes
1answer
49 views

Calculated column to determin a due date of a record

I'm looking for some help. I'm trying to setup a calculated field to determine a due date of a record. The due date needs to exclude weekends, and also is dependent on two addition columns. ...
0
votes
1answer
139 views

SharePoint 365 List DateTime column needing no Time Zone affiliation

I have a SharePoint 365 custom list for my configuration team to receive requests from our internal business customers. There are date time fields for start date and end date of the configuration ...
0
votes
1answer
57 views

Need to show time difference in negative

I need to calculate a difference between two times and it should show negative value if the value is negative. Say Time 1 is 29/04/2019 11:30 PM and Time 2 is 29/04/2019 12:00 PM. I wat the difference ...
0
votes
0answers
77 views

Refinablestring Date Column Range Results using Search Rest API

We have a Document Library in SharePoint Online with Date Column and it was mapped to RefinableString00 Managed property. currently we are getting the search result using the below api url "/_api/...
0
votes
1answer
78 views

Set date column default for specific time on day

I have a date and time column in a SharePoint document library Is it possible for the default value to be a certain time (e.g. 1pm) on the day of creation?
0
votes
1answer
38 views

How i can set a Date/Time field to be required if a People/group field contain a value

I am working on a custom list inside sharepoint online classic UI. and inside the custom list i have 2 fields:- "ResponsibilityOwner" --> People/Group which allow single value. "...
0
votes
1answer
21 views

Event Recevier gets wrong date in itemAdding

I have an event receiver in sharepoint online and it is deployed in azure. so i noticed that it is returning the wrong date and have noticed that it gets the previous day if the time is 12:00AM. ...
0
votes
1answer
49 views

Calculated Field to show difference of hours as value

Hello I have three fields hours1, hours2 and total hours. Total hours is calculated fields based on the sum of hours1 and hours2. I use the formula =VALUE(TEXT(total hours,"hh"). It works if sum of ...
0
votes
1answer
71 views

Start time field calculations on calender events fails on full day event entries

I think I have found a bug in Sharepoint regarding date fields and calculations. Here is how to replicate: Make a sharepoint event/calendar list (where items have a starttime and end time) Make sure ...
0
votes
1answer
481 views

Filter dropdown/lookup field based on date

I have a Secondary List(B) that my Primary List(A) uses to populate a field in InfoPath called 'Current Pay Period' which is a drop down. List B contains a calculated column to display dates since ...
0
votes
1answer
26 views

Calculate dates between now and a specific date

I am trying to have a calculated item between two dates. What I am hoping to do is, get this item to calculate the date difference between now and another date (provided by the submitter) I tried =...
0
votes
1answer
52 views

SP List dropping date format

I have a sharepoint list that has a timestamp in one of the columns. I'm adding the timestap via MS Flow. I need the format to be yyyy-MM-ddThh:mm:ssZ (so i can compare later in a REST call) but ...
0
votes
1answer
21 views

Check a box based on last Monday of the month?

Is it possible to have a check box automatically tick based on a date if that date is the last Monday of a month? How would one accomplish this? Thanks.
0
votes
0answers
177 views

After change regional settings, pages with SPFx webparts gives unexpected error has occurred

After change regional settings in SharePoint 2016 On-Premise server to Bulgarian, Macedonian оr other Locale I have following error: Error from log file by corelation ID is: Message : System....
0
votes
0answers
2k views

REST API Date Time Zone issue

I am fetching records from the list using rest api by filtering date field in it. however i am getting a different result from different time zone. any kind of help will be appreciable. var today =...
0
votes
2answers
102 views

Concatenating a date field to a drop-down based time field

I am trying to create Start Date/Time and End Date/Time fields. Here are my parameters: Start Date STime (drop down) End Date ETime (drop down) Start Date/Time (calculated) =concat(substring-before(...
0
votes
1answer
111 views

Date/Time Difference (Workhours/Workdays only)

I have a rather complicated (to me) Date/Time question. I have a multi-step workflow, and am trying to build two calculated columns to track the elapsed time in business hours (M-F, 0800-1700) ...
0
votes
0answers
154 views

Current time in sharepoint designer 2010

I create a workflow in SharePoint designer 2010. For each task I have to create a event in a calendar. To get a current date and time I modify list item and use "Pause for 1 min" (without pause, ...