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
2answers
346 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&...
3
votes
3answers
3k 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
86 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
62 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
48 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
54 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
531 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
949 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
82 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
199 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
53 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
26 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
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 ...
1
vote
1answer
103 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
4k 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
680 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
168 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
481 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 ...
0
votes
1answer
535 views

Set EndDate to value of EventDate with jQuery

how can I set field EndDate automatically to value of field EventDate with jQuery after user choice EventDate from calendar? I use code, but it doesn't work for me: <script> $(document)....
1
vote
1answer
1k views

Can hours be added to a Task List?

I am using SharePoint 2013. I created a Task List and am taking advantage of the Start Date, Due Date and Timeline. Instead of a Start Date, Due Date, is there anyway for Hours to be added to just ...
1
vote
0answers
341 views

SPUtility.ParseDate - format of the input date string

In the SPUtility.ParseDate function, the 2nd parameter is the date in string format. Is there any specific format required for this? Will it work with any format? The MSDN documentation for this API ...
2
votes
2answers
211 views

Unable to get event item time in SharePoint online calender list

I'm writing simple JavaScript. In that script I'm getting Event item Start date field value and End date field value from Custom calendar list. but the code retrieve different time Example: here is ...
1
vote
1answer
867 views

Find Days between dates gives me a fraction

I'm using a 2013 workflow that starts on creation, and the Find days between dates code. I'm getting the time from the "Due Date" field on the list, it comes with a time, so I set time for 12:00:00 in ...
0
votes
1answer
59 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
1answer
152 views

SP2010 Designer Workflow: Wait Until ([Date&Time Field] - 1 Hour)

I have a "DoneBy" Date & Time field on my custom "Tasks" List. The requirement is to send an email reminder when there's 1 hour left until "DoneBy". Is it possible to achieve this using "Wait" ...
0
votes
1answer
260 views

Default date to the next Tuesday

I used this formula =TODAY()+MOD(10-WEEKDAY(TODAY()),7) in a calculated field which seems to work. However, as TODAY is actually Tuesday, Sept 13, I need the date to reflect next Tuesday, Sept 20. ...
1
vote
1answer
31 views

Split up @ArticleStartDate Month and Day to resemble a calendar page

Using SharePoint 2013, I have a custom ItemStyle.xsl file where I have the following code: <div class="articledate"> <xsl:value-of select="ddwrt:FormatDateTime(string(@ArticleStartDate), ...
1
vote
2answers
388 views

Date Column Validation - Must be 10th of Next Month

I am having trouble setting up my Column Validation formula on a list. I need to restrict the field to only be the 10th of any given month. I found the below answer, but I don't want it to be the ...
2
votes
1answer
28 views

Create a Datetime from Modified with Static Time

I have a need to create a Calculated Column that is a Datetime based upon [Modified]-1, but with a static time of 11:59:59 PM. Something like this: =DATE(YEAR([Modified]-1), MONTH([Modified]-1), DAY([...
1
vote
3answers
48 views

Move position of choice field beside DateTime field

please help me. I've got custom New event formular and I need arrange fields in it. I need move choice field "Termin od" beside Date&Time field named "Čas začatia", moreover how can I hide name of ...
2
votes
2answers
2k views

Format Date using CSR (dd.MM.yyyy)

I´m using SP2013 and i have a Shift Plan which colors the row from TODAY in yellow. var today = new Date(); // zero out the time portion so we will only compare days today.setHours(...
2
votes
1answer
541 views

SP2010: Compare the value of a date column with today's date

I've a column D in a list of type Date and Time which takes only date values (not time). I want to write a javascript function to check if the value in D is less than today's date (only date, not time)...
5
votes
1answer
1k views

SharePoint JSOM datetime values in different timezones

I am working on a solution (on SharePoint Online) which is used by users in different timezones. SharePoint site is configured for "W. Europe Standard Time". Following occurs: A user from US creates ...
2
votes
1answer
1k views

Change Date Format in SharePoint 2016

I want to change the format of date from MM-DD-YYYY to DD-MM-YYYY in list, Gantt charts etc. I have tried one option so far but it doesn't work properly which is explain below: First option: I have ...
3
votes
3answers
4k views

SharePoint views - Filtering by date and time

We have a custom web-part that uses a View to filter Procurements (Tenders) by date. We are trying to filter the view using the [Today] function but from what I gathered it only uses the Date and ...
0
votes
1answer
43 views

Showing list results for today from a set of dates

I have created a list with: 1 column with a start date 1 column with an end date I'd like to set up a view where it will check and show only the items where the current date is included between the ...
4
votes
4answers
562 views

How do I create a calculated conditional column using today's date, and automatically update each field daily?

I have created the following list (Timeframe) in SharePoint; Timeframe Start Date End Date Another column, [Is Current Timeframe], needs to be created that specifying whether or not the Timeframe ...
2
votes
1answer
299 views

Format SharePointWebControls:DateTimeField

I am using this to return the date/time entered by a user in a page layout. I want to only show the date. I need to keep the time part as this is used in a query on another page. I have seen ...
1
vote
0answers
448 views

Document Library Date/Time gives “Invalid datetime value” error after changing site regional settings

Using Sharepoint Online, I've created a new column on a document library "Expiry Date". This worked fine until I changed the sites regional settings from English (United States) to English (United ...
0
votes
2answers
983 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 ...
2
votes
2answers
128 views

Setting a Workflow variable as a long date

I have seen all the suggestions for extracting the day of the week from a long date in a SP workflow. I would love to be able to set my date/time variable to a long date but the system will not let ...
0
votes
1answer
538 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 ...
3
votes
2answers
1k views

Is there a way to make a workflow run every Monday?

Context: I have a list that we use as a sort of newsfeed. I have a workflow which, when an item is created on the newsfeed, copies the contents into a new list item on a secondary list. What I am ...
3
votes
0answers
140 views

SharePoint Calendar takes next day at 23 hours

I have a SharePoint custom Form where I have SharePoint Default date column and three custom controls for Hours minute and Second. So by default on page load,the date in SharePoint Date Field is taken ...
0
votes
2answers
3k views

Calculated field - If date = date then return another date, otherwise date

I have two fields, StartDate and NewDate. The NewDate field, I want to calculate based on StartDate and return a date. If the Start date is greater than or equal to 3/31/2016, then enter 4/26/2017 in ...
1
vote
1answer
979 views

How to Display Correct Times for Users Regardless of Their Time Zones

I have an InfoPath form on my List. One of the controls on this form is called LoggingTest of type "Multiple lines of text". Below are the settings for this column on my control: The purpose of the ...
1
vote
5answers
2k views

workflow 2010 will show a Date equal to 01/01/0001 inside the email, if the Date is empty

I am working on SharePoint server 2013, and i create a new Workflow 2010 inside Sharepoint designer 2013. now inside the Workflow i set an email which contain the following value:- [%Current Item:...
3
votes
1answer
115 views

Sharepoint Jsom return wrong time

I have custom column, interview date, in custom list and I am storing date and time in column. When I fetch interview date data then it will return wrong time. If I store value in field 26 May 2016 ...
1
vote
3answers
885 views

Showing Due days in a red colomn based upon the real date of this day and a due column date

I'm trying to figure out, how i could show a list with having real overdue date's in days based upon the current day. (maybe a client side rendering?). The problem is calculated column can not make ...
0
votes
1answer
72 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 ...