The date-time tag has no wiki summary.
0
votes
1answer
127 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
388 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
1answer
565 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
196 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
12 views
A reusable 2013 Workflow is not updating a date field which is marked as required
Good Morning,
I have a date field in a SharePoint 2013 list that is marked as required. I need to update it to add the number of days in a payment terms field in a separate list. The target field ...
0
votes
0answers
44 views
Convert Local Time (SSRS datetime parameter) to UTC Time
I am working with SSRS 2008 and SP 2010. My report has 2 parameters 1. TimeZone this parameter is read from SharePoint site (timezone of the site as per regional settings) the other is simple datetime ...
0
votes
2answers
36 views
Validat Data on Date And Time Column not work on editform.aspx on sps 2010
i have a pronlem on validation on edit mode of list items.
my a simple list have a column named : "StartTime" with date & time type.
and i add this validate rule : "=[Created]<[StartTime]"
it ...
0
votes
1answer
53 views
Date column value changes because of DST
A list includes a column "Date" of type Date and Time, Date and Time Format is Date Only. An item is saved via web-service and is set to value such as 2013-04-01T00:00:00Z.
When this same item is ...
0
votes
1answer
37 views
All Day Event = False throws a workflow error
I have a workflow item that I am stumped on.
It is very basic...
1 If All Day Event equals True
2 Log >SET TIME<
3 then Store [%Date%] in Variable:TimeFrame
4 then Log - OK
5 Else If All ...
0
votes
1answer
87 views
Getting Filtered results by Date column from a list with BCS and SharePoint 2010 JavaScript Client Object Model
I'm trying to get the filtered results by a column type DateTime from a list filled with BCS using JavaScript.
I've tried everything to get those results with query like:
"<Where>" +
...
0
votes
0answers
57 views
SharePoint 2010: Non-mandatory date field is prompting for a date upon item edit
Morning all,
My current set-up is SharePoint 2010 Standard RTM.
My scenario is thus.
I've created a series of content types for internal auditing purposes. One of the fields is a date/time data ...
0
votes
1answer
307 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
0answers
66 views
Getting Date Range Between Start and End Date
I was wondering if I can get the date range that is specified by a user with a start and end date in Infopath. The requirement for this is that the user must only enter a start and end date. I need it ...
0
votes
1answer
43 views
How can I get a daily hour value from a date/time field?
I am trying to calculate the amount of time on a daily basis.
Currently I have calculated "[total hours per diem]", "[total days]" and the time values (if not split over multiple days).
Where I am ...
0
votes
0answers
21 views
SharePoint Designer Workflow Logic
I am trying to build a workflow to update certain dates based on a based date. As far as I know if can only be possible via SPD workflow. Here is the logic:
I have three date fields. BaseDate, D1 ...
0
votes
1answer
72 views
Daily and weekly alerts always send
I have created sharepoint alerts programmatically. If I check 'manage my alerts' all values are correct such as "Weekly", "Friday", "6:00pm" then I add an item to the list and receive an alert email ...
0
votes
0answers
17 views
How to find the exact time of restore completion of a site backup
This is a very basic question. When we restore a site backup in SharePoint , does SharePoint logs the date time of the completion activity after it has successfully completed. In the powershell it ...
0
votes
1answer
77 views
SearchCoreResult returns Regional Date Value
I got the following formate returned from "Write" in english:
<write>09/12/2012</write>
I parse that with the following line and return a german format: 12. Sep.
<xsl:value-of ...
0
votes
0answers
97 views
how to upload document from c# application with datetime/choice column
i have created an application to simplify uploading file to document library and i am having problem with 2 fields which is datetime and choice fields of the document library, the file is not ...
0
votes
1answer
109 views
Want my column display minutes and want it to sum in hours
I have an issue again...
I create list from csvfile. I convert string with date into DateTime type like this:
string[] formattedDates = { "dd.MM.yyyy HH:mm:ss", "mm:ss", "HH:mm:ss", "dd.MM.yyyy", ...
0
votes
2answers
186 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
0answers
145 views
Sharepoint 2007 DATEDIF error on negative numbers
I am creating a list to determine how long it is taking to review a document. I have a column named Due Date and a Column named Review Complete.
I want to calculate the difference between the two. ...
0
votes
0answers
56 views
Time Difference when uploading Files and Content Deployment Time
Our Sharepoint WebApplication has been setup with EST time . In the Regional settings of the SiteCollection it is also mentioned in the same way. Our Sharepoint Server also has been configured to take ...
0
votes
1answer
114 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
0answers
189 views
In Sharepoint 2010 BCS, how do I save a column of type DateTime that allows Null values?
I'm developing a Sharepoint 2010 BCS using Visual Studio 2010. One of my requirements for this particular ECT is that it have a datetime column that's not a required field. The column in the database ...
0
votes
2answers
719 views
ddwrt Schema Unavailable?
So:
I'm trying to use the ddwrt:FormatDateTime function in an XSL transform, but I'm getting the following error:
Exception details:
Method: ...
0
votes
1answer
553 views
Calendar DVWP to show only today with recurring and all day events
I got a interesting problem here. I developed a dashboard for one of our departments, they wanted a widget that shows only today's events. I have the DVWP in place, and filtering by a calculated ...
0
votes
1answer
326 views
Having problem inserting JQuery Date into List
The situation
I am using the Time Picker Addon (http://trentrichardson.com/examples/timepicker/) to allow user to select a date in the format of YY-MM-DD HH:MM:SS.
The date is insert into a ...
0
votes
1answer
56 views
DateTime Column type for import
I am looking at this http://spfileupload.codeplex.com/ to import files/folders with metadata. but it seems that DateTime is not supported. What's your input on this?
