Questions tagged [date-time]

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

124 questions with no upvoted or accepted answers
Filter by
Sorted by
Tagged with
1
vote
0answers
142 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
148 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
253 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
55 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
172 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
20 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
217 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
93 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
196 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
597 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
313 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
285 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
969 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
26 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
27 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
0answers
19 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
29 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
38 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
34 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
0answers
27 views

How to change the below explained validation from inline style to ms-form validation on migration from SP 2010 to SP 2013?

After migration from SharePoint 2010 to 2013, when we add an element and miss any mandatory field, we should get the validation errors. But in my case, when I fill the Authorized Date field and miss ...
0
votes
1answer
34 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
19 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
28 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
0answers
65 views

Prevent timezone issue and save date time as is in SharePoint using JavaScript

This maybe a common issue but my requirement is below. 1) user selects date and time using Bootstrap datetimepicker 2) If user selects 15/9/2018 12:03 PM, it should save as is Currently the timezone ...
0
votes
1answer
42 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
252 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
24 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
46 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
20 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
151 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
1k 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
61 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
92 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
124 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, ...
0
votes
1answer
309 views

Calculated column to show differece between start time and end time

I have two date columns in a custom list: Start time and End time, both are set to today's date and just select the time. Now I want to add a new column that will automatically show the subtraction ...
0
votes
1answer
55 views

Calculate hours and rate to equal charge

Ok so i am trying to figure a couple of things out on sharepoint o365, So the fields we are working on are Start time, Finish Time, Total Time, Rate, Billable. So currently we work out our total time ...
0
votes
1answer
963 views

Date and time validation

In my SharePoint 2013 I have 4 columns Start Date (date only), Start Time (Single line of text, max 5 characters), End Date (date only) and End Time (Single line of text, max 5 characters). I want to ...
0
votes
1answer
47 views

Send mail on a specific date but supress if date changes

I have a simple sharepoint list with a user id a deactivation date and a field indicating that the email has been sent. The goal is for sharepoint to send an email warning the user id that their ...
0
votes
1answer
61 views

Sharepoint 2010 Workflow Triggering emails ahead of date

I want to create a workflow that will look at a date in a column and then send an email 60 or 90 days before that date is current. What would a workflow look like to do that? Would it be easier to ...
0
votes
2answers
1k views

Content Search WebPart: query Date and Time field

I have calendar list, Now trying to query items which is greater than Today. so first I have created new managed property with name EventDate and mapped the crewel property ows_EventDate with type ...
0
votes
1answer
543 views

How to validate Date type column value in SharePoint list?

I have date column in SharePoint list, which is basically for a license file application. So I want that the user cannot select date unless and until he is 18+ years. What formula do I need to apply ...
0
votes
1answer
73 views

Time Displaying Incorrectly on InfoPath Form and Not Displaying Current User

I have 2 controls below. The top Text box is labeled CommentsTemp while the bottom TextBox is called Comments. How it works is, when a user enters anything in CommentsTemp, that it would be stored in ...
0
votes
1answer
1k views

Time Difference in SP Calculated Column excluding weekends

I have two dates (Initial Date & End Date) both date and time format in a SP List. I need to calculate the amount of days between both of them excluding weekends. I already have the formula in a ...
0
votes
2answers
1k views

Setting End Date to same as start date

I have a list that I created to track start/end times for activities. I'd like to set the form so that when the user enters the start date it populates the end with the same date so that users ONLY ...
0
votes
3answers
380 views

How to restrict date(Created) field to display only date and time?

How to restrict the date field(Created) to show only date and time instead of Fri Apr 15 2016 16:06:04 GMT+0530 (India Standard Time)? I do not want to show GMT and so on. The below is my code. ...