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
1answer
580 views

How to get items created in month of Feb using REST query irrespective of year [duplicate]

I want to create such a query using REST that returns me items created in the month of February. To do so I searched for the functions we can implement to the REST query and I have found month() ...
1
vote
1answer
912 views

Date value in SharePoint is one day off while retrieving

I am saving a DateTime value in one of the field in SharePoint list : //request is an entity that has all he fields in the list, I am only showing DueDate in the below code if (txtdatepicker.Text ...
1
vote
1answer
53 views

Collect Data from a User - Date and Time (without seconds)

I am creating a workflow in Sharepoint Designer 2010. In one of "collect task" I have a field "Meeting date": Information type: Date and Time Display format: Date and Time My problem is that in ...
0
votes
2answers
96 views

Format sharepoint server time with javascript

I retrieve server date using javascript using JSLink like: var currentServerDateTime = new Date(_spPageContextInfo.clientServerTimeDelta); But I want it into format "dd/mm/yyyy", how can I achieve ...
1
vote
2answers
812 views

Get date format of current site which is set in regional settings using JSOM

I need date format of site, I can get date separator using get_regionalSettings() and get_dateSeparator() . I tried get_dateFormat() but it returns "1". I need to know date format of particular site ...
2
votes
1answer
3k views

Add 2 hours to calculated Date and Time field

I have calculated Date and Time field with Formula =NOW() is possible to add 2hours using formula?
1
vote
1answer
355 views

SharePoint 2013 Content Query Tool Part - How to format a “Date and Time” display field?

In the Content Query Tool, I'm pulling data from a task list, and for the Description, I want to display the Due Date. In the list itself, the Due Date is set to Date Only, Friendly Display Format (ex....
0
votes
1answer
436 views

CAML to Return rows Where Created is Between 2 dates

The below query returns the entirety of the List, instead of those which fall inside the correct date range. I have tried querying with and without a time added to the date. CamlQuery ...
1
vote
1answer
133 views

Calculated Date [Sharepoint Online]

Currently having an issue with a calculated date column when the field is not filled in. Displays the date as December 1899. Current formula is: =TEXT(YEAR([Closed Date]),"00")&"-"&TEXT(...
5
votes
1answer
762 views

Is there a way to change the Date format inside SharePoint sites to be shown as DD MMM YY (i.e. 25 March 2017)

I am working on a sharepoint farm on-premises 2013. currently we set the following for the regional settings:- Where all the date fields are being shown in this format dd/mm/yyyy for example ...
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(...
5
votes
1answer
3k views

Time Difference Formula in Calculated Column

How Can I achieve displaying time difference between two type "date and time " columns? I want to put the time difference in another column type "based upon calculation" of those two. I want to ...
2
votes
1answer
62 views

Can we convert Sharepoint date/time to XSD date/time

I have requirement to convert SharePoint date and time to xsd date and time. can we do this in SharePoint. Any insights would be great.
2
votes
1answer
74 views

Calculated Column that will trigger the word “expired” in another column

I am looking to create a calculated column that will trigger the word "expired" in another column if the date is less then or equal to today's date. Do you know what formula I would use for this?
2
votes
1answer
101 views

3rd Tuesday Calculated Column not working when there are 5 weeks in the month

Looking for some assistance on why my calculated column formula doesn't work when there is 5 weeks in the month. I have one column called Current Patching Date (date/time field) - stores a date I ...
1
vote
1answer
734 views

Update the display format value with CSOM

I have SharePoint list hosted in SharePoint online. I need to change the display format for the modified filed to standard from friendly using CSOM code. I am able to do it through UI. Below is the ...
0
votes
1answer
3k views

How to calculate Days, Hours and minutes between two different dates and times

I have a Start Date and Time column and a End Date and Time column, I also have a calculated column using a Single Line of Text formula: =TEXT([End Date and Time]-[Start Date and Time],"d:hh:mm"). ...
0
votes
1answer
1k views

How to change list item date time format type using c#

I am making a sharepoint web appplication. when I show the data from sharepoint lists, I want to change DateTime format type. For example, "Created" item showed like this now [2017-06-15 PM 3:23:33] ...
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) ...
3
votes
2answers
3k views

Query the year from a date field in CAML Query

I have a SharePoint 2013 list in which I have a date field say Formatted Date, now using CAML Query I need to retrieve only the records which have year 2017 in the Formatted Date.PFB my code: $()....
1
vote
1answer
579 views

Site Regional Settings time zone vs User Profile time zone - how does this work

I'm working to define requirements for a site collection with 50+ sub-sites. The company is based in the Central Time zone. We will have internal and external users, but all will log in to access the ...
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, ...
2
votes
2answers
2k views

How do I add hours to Now() after converting it to a text value?

I have a calculated field that shows the text value of the current hour, so I'm using: =TEXT(Now(), "hh") Unfortunately, it's showing this value in Pacific time, so I'd like to add 3 hours to ...
0
votes
3answers
1k views

Using Moment to format a date from a Sharepoint list

Afternoon I'm new to using Moment and need to format a date from SharePoint in JavaScript. The variable is LifeCycleStart and I don't know the right way to format it and drop in Moment. Here's what ...
1
vote
1answer
1k views

SharePoint Conditional Formatting Date Column

I've been trying to create a Conditional Color column for dates that are expired. The expired dates should be red and the dates that are not should be clear. I tried to use the code from http://www....
0
votes
1answer
413 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
97 views

SharePoint Calculated column to Check If today is 14th date

I have date time column called Today. I'm trying to create calculated column which check today is 14 Value for Today column is 4/13/2017 I m trying to check that is today is 14. means like this (4/...
0
votes
1answer
437 views

incorrect of sharepoint 2016 datetime field value

I have just created list and in that list I create a datetime field, and I developed a C# program to get the list data, but when my program get datetime field value, have a wrong, in my sharepoint ...
2
votes
0answers
25 views

Can we compose REST query which first apply some function on item then compare?

I have a date which is in Indian time zone, my SharePoint Online site is in different time zone. Now I have a rest query which filters the record. SiteUrl/_api/web/lists/getbytitle('ListName')/items?$...
3
votes
2answers
6k views

Sharepoint 2013 - custom display form - time/date not formatted correctly

I have an issue on my display form with formatting. I have set the language and region correctly - and chosen time and date in a friendly format. When I enter the time and date it all looks fine - but ...
4
votes
3answers
500 views

Sum of two Time columns

There are two calculated columns that display times of two date columns. I want to sum those two "time" columns. Any suggestion is greatly appreciated. Example: column 1: 16:35 column 2: 14:00 So, ...
0
votes
2answers
524 views

Whats wrong in given caml query?

I am trying to get the data based on some datetime string using CAML query. Here is my CAML query: <View> <Query> <Where> <And> <Le&...
6
votes
3answers
4k views

Difference between two dates in hours

In SP list there are two date/time columns, column A and B. I want to calculate difference in hours between those two dates, but only on working hours. My working hours are between 8AM (08:00) and 4PM ...
1
vote
0answers
99 views

How can I create a DateTime for a specific time with the correct UTC offset in an SP2013 workflow in VS?

I'm trying to pause a workflow until 8 AM on a specific day. I am on the East Coast of the US: UTC -5. I can create a DateTime object with a time of 8 AM like this: new DateTime(DateTime.UtcNow....
0
votes
1answer
64 views

Project Pipeline - Current Date

Good Afternoon Folks, I have a client that is trying to make a "Project Pipeline" graph in SharePoint, show the current date and out rather than the beginning of these elements (starting back in ...
2
votes
2answers
52 views

Calculate DATE with based on column + IF statement

my calculated date/time function is failing on sharepoint 2010 and I'm not sure why. =YEAR( [Tested:] +IF( [Maintenance Recurrence:]="Yearly" ,1 ,0 ) ) ...
0
votes
1answer
58 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
652 views

SPO - Hosted Add-In: String was not recognized as a valid DateTime

I want to save data in format: dd/mm/yyyy to SPO server. My regional settings is set to alert(regionalSettings.get_localeId()); //1026. How to solve this problem ? This is my code: oListItem....
0
votes
1answer
1k 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 ...
2
votes
1answer
93 views

Is there a way to remove the time displayed in the scheduling end date column?

We've created a view of expired pages showing last reviewed date and scheduling end date. Our last reviewed date can be formatted to just show the date, but can't seem to do this with the scheduling ...
1
vote
1answer
268 views

SP13 - Con app How to set string to DateTime Field

I want to to set string to DateTime field programatically with C# Object model This is my code: string date = "11.13.1992 г."; //DateOfRegist(Date Time) addItem["DateOfRegist"] = DateTime....
1
vote
0answers
57 views

Datetime querystring format when paging the sorted list-view

When I sort a column (ExpiryDate) in the list view and then click next page button, SharePoint generates URL like this: http://www.example.com/Lists/WatchList/AllItems.aspx#InplviewHash0691b043-5378-...
0
votes
1answer
27 views

Test to appear as login from different timezone(country)

how you can make think SharePoint that you have logged in from different country. Currently i am in USA east cost. How to log into SharePoint appearing from logging in from UK
0
votes
1answer
48 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 ...
1
vote
1answer
121 views

cqwp: formatting a date inside a standard template

I do not have a formal knowledge of XSLT so my successes are with attempts. I would like to know one information once for all. Sometimes I need a slight modification on the templates such as the '...
1
vote
1answer
5k views

How to pass null value to a DateTime field sharepoint rest?

I want to update a field 'End Time' of type DateTime in my Sharepoint list. I want to update the field('End Time') with null.Whenever I try this I get an exception "Input string is not in correct ...
3
votes
1answer
898 views

Need help comparing two dates with times

I'm trying to compare two dates with time. I'm able to compare just the date, but when I add the time element it doesn't work. I'm not sure what the correct format should be. <xsl:if test="ddwrt:...
3
votes
1answer
195 views

AJAX get for this weeks birthdays

Greetings fellow sharepoint warriors. I am trying to understand the way all the filtering goes and I've stumbled upon a problem. I would like to get items from list where birthday falls in current ...
1
vote
1answer
744 views

How to add time (in years) to a date and time column.

I am trying to create calculated column in a document library where a person assigns a task to another person and set next review date. There are two columns: 'Time' which is a drop down column ...

1 2
3
4 5
10