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

learn more… | top users | synonyms

0
votes
1answer
65 views

date column validation

Is it possible to validate the end date to be not greater than by 30 days over the start date? So if the Start Date is February 18, the End Date cannot be more than 30 days past February 18. Thank ...
0
votes
1answer
204 views

CAML query datetime - publishingstartdate

I'm trying to get a CAML query working with dates - specifically PublishingStartDate and PublishingExpirationDate. When scheduling an item, there is the option to select 'immediately' and 'never' ...
0
votes
1answer
38 views

How to specify a specific range of dates

I have a List that tracks certificates. I need to limit two of the input fields and I'm not sure how. I have a formula (=[Expiration Date]>[Last updated]) in place that prohibits an Expiration ...
0
votes
1answer
62 views

DATEDIF in Workflow

Is it possible to use DATEIF inside a workflow? Right now I have: =DATEDIF(TODAY(),[Expiration Date],"D") Is this possible inside a workflow if? is there a certain benefit to it? Thanks.
0
votes
2answers
452 views

Set default date based on date other date column

I'm fairly new to SharePoint and I'm still learning the terminology so please excuse I have 2 Date Time columns in a SharePoint list, Date Received and Due Date. The Due Date is supposed to be 30 ...
0
votes
3answers
60 views

How can I sort this by an actual DATE?

I have a calculated field in a document library that takes the "Modified" property makes a more readable date from it. The problem is, the column is now sorting alphabetically, even though the data ...
0
votes
1answer
343 views

Time variables with SharePoint Designer Workflows

I there a way to set up set up a workflow variable or condition to find [TODAY] - 180; using SharePoint Designer? Update: Would using this in SharePoint designer work for finding list items 180 days ...
0
votes
2answers
1k 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
56 views

Hiding Hour / Minute Options for Time/Date Column in forms

SharePoint 2007 environment. If I wanted to limited the options in the hour column (10 - 17 hrs) and time intervals in the mins slot (30 mins only), what's the best way to achieve this. I'm thinking ...
0
votes
1answer
59 views

Date Time ins LIST

I Have a list (Orders list) where i have a column "CreationDate" as internal name. That column stores datetime of the order. When I show this column in a View, it appears in the format "dd/mm/yyyy" ...
0
votes
2answers
198 views

GetFieldValueAsText DATE plus 1 hour

I have a GetFieldValueAsText converting DATETIME with 1 hour plus: 29/01/2014 14:26:45 after GetFieldValueAsText I get 29/01/2014 15:26 Someone can help me? Thanks
0
votes
1answer
2k 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 ...
0
votes
1answer
200 views

Sharepoint 2010 itemadded eventreceiver datetime parseexact fails (sometimes)

I have an event-receiver set up for sharepoint that runs a query against Oracle and then parses the returned date string. The SQL SELECT statement is built like this : TO_CHAR (TRUNC (dateinfo), ...
0
votes
2answers
843 views

Set current date i.e [Today] in a list column

I have a requirement where in user wants a column to be populated with Current date i.e Today. I went through many posts and found it is not possible to use Today() in list columns. The reason why ...
0
votes
2answers
930 views

Get Elapse time from Created and Modified Columns

I'd like to created a calculated column which subtracts the modified date/time from the creation date/time, is this possible? EDIT: This worked for me - =TEXT(B2-A2,"h:mm:ss") replace the cell ...
0
votes
2answers
227 views

Keyboard shortcut to Insert 'Today's Date' in SharePoint 2010

Does anyone know if there is a keyboard shortcut to insert 'Today's Date' in a Date field in SharePoint 2010? I've looked at the Microsoft Office SharePoint 2010 Keyboard Shortcuts and I do not see ...
0
votes
1answer
5k views

How to determine business days in sharepoint workflow

One step of my workflow needs to calculate how many BUSINESS days i have between two dates. The problem is that my customer registers the holidays in a sharepoint list. So i will need to query this ...
0
votes
2answers
902 views

Showing only last six months in a dropdown

I have a month column (a choice column) in my document library. Its format is, for example, "Jan 2013". I have the following requirements: The month dropdown should always show only the previous 6 ...
0
votes
2answers
7k 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 ...
0
votes
1answer
807 views

Issue using ddwrt:FormatDateTime in xsl variable

I have a data view and am trying to filter using 2 date filter web parts. I'm assigning the date filter values to parameters ($StartDateFilter and $EndDateFilter). I'm struggling with the filter data ...
0
votes
1answer
775 views

Calculated Column Incorrect when All Day Event is selected

I've created a Calendar list. I've added a single calculated column ("Calculated Start Time") that simply references the "Start Time" column. It reports the correct date when the event is not an all ...
0
votes
1answer
1k views

How to check DateTime condition in CAML Query?

I want to fetch the records from List which are created in Last 5 minutes. I have written following code, but its not working. giving me error. <Geq><FieldRef Name='CreatedDate' /> ...
0
votes
2answers
441 views

SQQuery, Dates and Regional Settings

First, some setup: My Site is set to Eastern Time, and the server is located in Eastern Time. I'm trying to run a query against a list using the created date. I have tried using all variations I can ...
0
votes
1answer
205 views

Capturing Multiple Time Zones in Sharepoint

I need to capture multiple time zones in our Sharepoint site. Ideally I would like to enter AEST and have the other files calculate/convert to the various other timezones. Is there a way I can do ...
0
votes
1answer
291 views

When is 'Article Date' populated?

I'm looking at different date fields of a Page I can use and have noticed there's an Article Date column under Publishing Columns. At what point is this column populated?
0
votes
1answer
906 views

Date and time column in Custom List form

I have created a Date and time type column in my custom list and have selected "Date Only" for Display format, but it is always displaying the options to select data as well as time on the form. ...
0
votes
1answer
352 views

Calculate Time Passed After Item Created Using Javascript (or other)

I have a list that tracks loaned equipment. I want a little icon that is a visual indication at how long the item has been on loan to help visually cue employees to follow-up. For example: 0-4 ...
0
votes
0answers
38 views

How to change date formating to yyyy-MM-dd

I have got this code: dzienStart = Convert.ToDateTime(properties.AfterProperties["DzienStart"]).ToLocalTime().AddHours(-1.0); dzienStart = Convert.ToDateTime(dzienStart.ToString("yyyy-MM-dd")); ...
0
votes
1answer
36 views

Calculate 70 plus formula

I am trying calculate a UAT 70 day view that adds 70 days to today's date which represented below by the "CalcToday" column minus the UAT START DATE field plus 70 days (mm-dd-yyyy). The formula below ...
0
votes
1answer
62 views

Create a Current Date and Time Variable in SharePoint Designer 2013

Is there a way to set or create a date/time workflow variable with the current date and current time in a 2013 SPD Workflow?
0
votes
1answer
70 views

JS Link View Overriding for date

I have a date column in my custom list. When i try to override the view of the field by using the TemplateOverride Function, my Javascript wont work on! The same problem occurs for Multiple Choice, ...
0
votes
0answers
16 views

How do I add Date and Time together for a Calendar view, maybe in workflow

We need the user to be able to select a Time slot when creating a new item, from between a cycle of 6 hours, so 12pm - 6pm, 6pm - 12am, 12am - 6am, and 6am - 12pm. They would also pick a Date. ...
0
votes
0answers
19 views

Search with other Date format doesn't work

I have a START and END site column of type date which are searchable. I've set the Locale in Regional Settings to Germany. Because of that the date is displayed in my lists in the following format: ...
0
votes
1answer
28 views

Central Admin > Web App > General Settings > Date/Time

SharePoint 2013 with Latest SP and CU: I have setup Central Standard time for a given web application. I uploaded a document and my local central time is 11:40am but time stamp is 10:40am that means ...
0
votes
2answers
112 views

Javascript CAML Query using DateTime

I have the following CAML: <Where> <And> <Eq> <FieldRef Name='Author' LookupId='TRUE' /> <Value Type='User'>473</Value> ...
0
votes
0answers
24 views

Business Connectivity Services DateTime formatting

I have a SQL Server database with a number of columns of type Date. I have used BCS to create External Content Types in SharePoint 2013 for the tables in my database. However when a view these content ...
0
votes
0answers
38 views

DateTime.ToLocal() in 2013 Workflow (British Summer Time problem)

I have a 2013 declarative workflow that I'm developing in Visual Studio. I grab the date from a column in a list and store it in a variable in the workflow. I have an email in which I want to display ...
0
votes
1answer
99 views

How to calculate the total days between two selected calendar dates

I've startDate = 7/16/2015 and endDate = 7/20/2015. This 2 dates are stored in a SharePoint list. If user select the exact date with the date in SharePoint list, it can calculate the total days = 2 , ...
0
votes
0answers
37 views

Date Comparison - Dataview Webpart in XSL

I have a site with Regional settings set for UK English and I'm using the following in xsl to compare a date field with current date value so that I can conditional formatting: ...
0
votes
0answers
50 views

How to unify date formats on web parts

I have three web parts on my SharePoint 2013 page which show an item with the latest date of modification. These web parts are based on: Announcement app (so basically list with customized layout, ...
0
votes
0answers
36 views

Render SPList Date Time Control inside a Non SharePoint iFrame page

I am rendering an SP Online List inside a non SharePoint web application. I have overcome the SP security issue of This content cannot be displayed in a Frame...... by adding the following top the ...
0
votes
0answers
14 views

How to set a default calculated date 36 hrs from “Now”, Excluding Weekdays

I can set the default to =Today+(36/24) but it calculates from 12am. I want it to calculate from the current time, so 36 hrs from Noon or after would be 2 dates ahead. Ideally, I would also like to ...
0
votes
1answer
127 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 ...
0
votes
2answers
28 views

Changing just the year for all rows in a date column

As the title says I need to change the year for all rows in a list to 2015 from 2014 but leave the month and day the same for each. Had this been built as a calculated date column it would be much ...
0
votes
0answers
53 views

CAML query to Filter data on “DateTime” on a sharePoint 2007 list

I am trying to create a web part as a report to filter list data based on date and time I've created CAML as follows <Value IncludeTimeValue='TRUE' Type='DateTime'> Further I've ensured ...
0
votes
1answer
34 views

How to validate on an absolute date?

I have a datetime field named "Date", and would like to only allow values within a specific range, say March 2015 - June 2016. Is there an easy way to do this? This rather hard one doesn't trigger any ...
0
votes
0answers
88 views

How to retrieve the ISO/original value of a DateTime column in a list using CAML?

I'm using SharePoint Foundation 2013 and I want to retrieve the data in my DateTime column. Is there a way to retrieve the original/raw values or ISO values of a DateTime column using CAML query? ...
0
votes
0answers
36 views

SP 2010 TEXT Function Subtracting 1 hour

I have a calculated column on a calendar that just formats the start time of an event. I am just using the TEXT function to format the time as hh:mm but for some reason the output of the function is ...
0
votes
0answers
18 views

datasheet view: colons instead of dots in time columns

I have a calendar in datasheet view on a Sharepoint 2013 site. When I enter a new calendar item and fill the "Start Time" and "End Time" , the time is not picked up correctly (from the time picker) ...
0
votes
0answers
54 views

Search in SharePoint 2013 by CreatedDate is not working

Search in SharePoint 2013 by Created Date is not working in advance search web part. I have created the site column in document library "ReviewExpirationDate" add data in it . after that full crawl ...