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

learn more… | top users | synonyms

1
vote
1answer
19 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
24 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 ...
3
votes
4answers
69 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 ...
2
votes
1answer
15 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
20 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
0answers
8 views

FullCalendar ViewRender after postback showing NaN - Calendar events disappear in safari

I am using fullcalendar js in my SharePoint 2010 site. I am having two dropdown filters in the calendar view. The first dropdown will perform a postback call using a c# webmethod and will fetch event ...
4
votes
2answers
3k views

Date column showing as “Date and Time” even though “Date Only” selected

In a workflow I have set up on a list, the email that is generated is showing a date with both date and time, with the time at 12:00:00 AM (using a lookup of one of the list's columns). Checking the ...
0
votes
1answer
18 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 ...
10
votes
4answers
23k views

REST API filter by start and end dates using 'today'

I'm new to filtering dates with REST in SP but am trying to do something like below but am not sure how to get today's date in as a variable into the request. I don't think I'm too far off so any help ...
1
vote
1answer
886 views

Date field validation in SharePoint 2007

I need to limit the Date field in a SharePoint 2007 list so the users can enter date from today and up to year after. How can i do it?
2
votes
1answer
784 views

Should SharePoint Alerts automatically adjust for Daylight Savings Time changes?

We have a SP2010 farm that is up to the October CU. After the time change, some users report that alerts that were sending out at 10am are now being sent at 9am. I've googled a fair amount and found ...
2
votes
1answer
18 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 ...
1
vote
1answer
251 views

How To Get Current Date In Long Date Format in a Site Workflow

I have a requirement to get the day of the week into a workflow variable in a SharePoint Designer Site Workflow. This means I do not have a "Current Item" that the workflow runs on. How can I ...
1
vote
1answer
925 views

Showing 1 Minute increments in time field with Sharepoint 2013 list

My company requires our list drop downs to contain time in 1 minute increments. Is there an OOB option I can update to change this? If not, are there any options without installing a third party ...
0
votes
0answers
13 views

Having trouble sending a date from a “Date Filter Web Part” to an “InfoPath form web part”

I am using SharePoint 2010. I have a list that has a Date only column and I'm using an Infopath form to submit items. I have two web parts on the page: 1. Date Filter web part and 2. A InfoPath Form ...
2
votes
2answers
4k views

How to display date in Page Layout in specific format

I am using the following code to display date in a publishing page layout. <SharePointWebControls:FieldValue runat="server" FieldName="Created" id="CreatedOn"/> This displays both date &...
1
vote
2answers
80 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.
0
votes
2answers
2k views

Validate Sharepoint date time control

I have two fields; one is normal text box used to generate system current date and the another field is <sharepoint :datetime control > I need to validate this two: the date selected in ...
0
votes
1answer
2k views

How to set the date on the DateTimeControl on SharePoint 2010?

Want to enforce the Users to select only Friday. As it does not seem to possible, would like to set programmatically when user selects the date. It works fine behind the scenes however on the browser ...
0
votes
0answers
25 views

How to calculate duration based on 4 dates?

On Sharepoint 2013 teamsite I have a report taking which is updated by the workflow to calculate each task and overall duration. Workflow adds task start and end dates, durations are calculated per ...
0
votes
1answer
43 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
252 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 ...
6
votes
1answer
811 views

SharePoint Bug? Conflict Error when saving a Page with a “Required” DateTime field in the page layout

I've just recently encountered a weird error / bug in SharePoint. Here is the scenario: I have a custom column "Test Date" that is of DateTime field type. The field is configured as required. It is ...
1
vote
0answers
30 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
44 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 ...
0
votes
2answers
55 views

Date time issue in Sharepoint Online

I am inserting the date to SharePoint lists date time column. The issue is that it is not storing the actual selected date. I tried it with this date "2016-06-08" and with this format (yy-mm-dd): ...
1
vote
1answer
39 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
4answers
130 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
45 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 ...
0
votes
3answers
59 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
49 views

REST API datetime range not working as expected

Background: In Sharepoint Online, I'm using the Sharepoint REST API for query a few records based on its creation date (column Created). I'm using the following variations of the REST query for get ...
2
votes
3answers
12k views

Check for empty date in SPD Workflow

Question How can I check for an empty date condition in a SharePoint Designer Workflow? Background I have a list called "Project" with multiple date fields. I have a calendar called "Project ...
2
votes
5answers
9k views

CAML Query Filtering with OffsetDays

I'd like to set up a CAML query in a Data View Web Part (DVWP) that works like this: If a date is not specified on the Query String, then show me items created in the last 30 days If a date is ...
0
votes
1answer
20 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
27 views

Week/month calculation based on create date

I am building a SharePoint designer worklfow (2010 mode). I want to be able to determine/calculate the week and month when a workflow is created and use this in the workflow itself. How can this be ...
2
votes
2answers
37 views

How to set Date Time Column

I have a column in my List that is of type Date Time. By default I want it to display the Date as Created + 14 days. I tried the below in the column settings: HOWEVER, when I click OK I get the ...
0
votes
1answer
36 views

How Do I Input Todays Date Into a List?

looking to add todays date into sharepoint list so that I can run multiple expiry timelines off other cells. Have looked online and tried the work arounds but can't able to get any working code. I ...
1
vote
1answer
17 views

Elapsed time driven Automated Reminder workflow

Am trying to create a workflow (SP 2013) that checks today's date, checks the date an item was created, and if it is a week old, sends an e-mail to to creator saying "we are still working on your ...
0
votes
1answer
66 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
1answer
30 views

Trying to make a difference between two dates, with days, hours and minutes

I try to make a difference between two dates, but displaying the days and hours. So I found a good idea on this website : https://sharepointonline.wordpress.com/2012/03/02/date-time-duration-using-...
0
votes
2answers
63 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
1answer
83 views

Validation Error When Submitting Custom Infopath Form on Sharepoint List

I recently created a new list for our employees to create new Goals using sharepoint. I created a content type called “annual performance goals” and created a custom new entry form using infopath to ...
1
vote
2answers
22 views

Calculated field for difference between two times

I have a list with a "Start" field and "End" field. I'm using a calculated field to determine the difference in hours and minutes between the two. Start - 9:00 am End - 10:30 am =TEXT(End-Start,"h:mm")...
2
votes
4answers
2k views

How to show two dates in one calculated column

I'm using Sharepoint Foundation 2010. I have two columns, start date and ending date. I want to make calculated column which shows both of them in the same column. Everything is okay till I add both ...
1
vote
1answer
199 views

CAML query format filter in DateTime column

I need to get the list item created on a particular date. The below caml query doesn't seem to work. It always retuns 0 query.ViewXml = @"<View><Query><Where><Eq><FieldRef ...
2
votes
0answers
49 views

Display datepicker on top of the forms's modal dialog

I have a custom item edit form and I have a couple of DateTime properties that has to be filled at the bottom of the form (using datepicker): So when I click the mini calendar icon to choose the ...
0
votes
0answers
15 views

Word Template's DateTime Always One Day Off?

I have a library with custom content type with .docx template. I have a 'StartDate' and 'EndDate' fields in the content type which are mapped to quick parts in .docx template. When I change the ...
0
votes
3answers
52 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. ...
0
votes
0answers
20 views

Comparing Calculated Date Columns

I have multiple calculated date columns and am using them to calculate some dollar amounts. These amounts are changing on every save, regardless of whether the day changes. Is this because the field ...
1
vote
2answers
3k views

REST API filter by month

I would like to filter a datetime field but I only want to filter MONTH var requestUri = "xxxx/getByTitle('Contact')/items?$select=CellPhone,mdate,ddate&$filter= Birthday ge '" + today + "'"; ...