The date-time tag has no wiki summary.
2
votes
3answers
347 views
Issue with Sharepoint DateTimeControl
DateTimeControl is inside grid and i bind grid inside !ispostback section, on row databound of grid i find that datetimecontrol and disabled it.
when button click(outside of grid) DateTimeControl ...
0
votes
1answer
32 views
TEXT formula does not work in SharePoint 2010
I try to find difference between two date and time value in SharePoint 2010. I have two common column (date and time) and I use this formula =TEXT(Column2-Column1,"h:mm:ss") but it does not work? I ...
0
votes
1answer
554 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 ...
1
vote
1answer
795 views
How to set empty value to DateTimeField WebControl?
We tried to use DateTime.MaxValue to set empty value for DateTimeField and it works quite nice on our test environment, but we get following exception on some production farms.
Exception: Ticks ...
2
votes
1answer
359 views
Making DateTime fields ignore user timezones
We have a number of forms using a standard DFWP to serve up some simple forms. A few of these forms have datetime fields only showing the date portion. We're experiencing some issues where user A in ...
1
vote
1answer
541 views
How to convert date field in single line of text using Calculated columns
I have created a calculated field for a content type in my Sharepoint 2010 and I want to return a date in the TEXT format because I am returning some text with it. The condition I have put in the ...
0
votes
0answers
14 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 ...
1
vote
3answers
44 views
Calculate the difference between system columns Created on and Modified on
I'm trying to create a new column in a shp list that contains the difference in days between two other columns in that list. These two columns are the custom list columns that contain the date Created ...
0
votes
2answers
41 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
0answers
47 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
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
92 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
1answer
38 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 ...
1
vote
1answer
142 views
sharepoint date column calculation
This is my first day using SharePoint and I was lost in trying to figure out how or if it can be done, custom column calculations, and if code is allowed in SharePoint? I am using SharePoint 2010. I ...
0
votes
0answers
62 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
355 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
67 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
22 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 ...
1
vote
1answer
108 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
0answers
148 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
1answer
77 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 ...
2
votes
0answers
299 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 ...
0
votes
1answer
131 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 ...
1
vote
0answers
98 views
How to make report in SharePoint 2013?
I am trying to make Report of Time registration part in SharePoint 2013. And I try to use Access View but SP 2013 doesn't have Access view or I didn't find out it. If you have any advice or suggestion ...
1
vote
2answers
253 views
CAML OffsetDays
please help if it possible that CAML OffsetDays is not working in DvWP?
I use the following CAML within a DVWP:
<View><Query>
<Where><And>
<Lt>
<FieldRef ...
1
vote
0answers
37 views
Combine 2 seperate date and time columns into one
I have 2 separate columns in a list document library one is date and one is time can they be combined with a calculated column? If so how?
Thanks
Lewis
1
vote
0answers
88 views
SOAP returns DateTime with timezone offset added to minutes
I am using the Ruby gem 'viewpoint/spws' (from a RHEL 6 server) to insert items into a Sharepoint list via SOAP.
It seems that the DateTime fields being passed are being incorrectly interpreted by ...
1
vote
0answers
52 views
Wierd format of Modified date and PublishingStart
Iam having trouble with date formats of these two fields: Modified and PublishingStartDate. They are different in format. Iam attaching how they display on my computer. I have regional settings set to ...
2
votes
1answer
195 views
FormField value set with javascript, value lost on postback
I have a custom list of "requests" which need to accommodate a required time range for a single date (among other fields), so I added "start" and "end" columns of date and time type. I used designer ...
1
vote
2answers
320 views
Display and Sort on Date and Time Managed Property
I'm using a CoreResultsWebPart to display the latest articles in a short list. To display the last modified Date and Time I've created a Managed Property called LastModifiedDateTime (I'm aware of the ...
0
votes
1answer
393 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' />
...
3
votes
4answers
3k views
DateTimeField and timezone conversion problem
It seems that the datetime value which is entered into a DateTimeField is always stored as UTC no matter what timezone is configured for the current user.
Only the output on the page is displayed in ...
0
votes
0answers
18 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 ...
1
vote
1answer
142 views
SP 2010 REST $filter column
I'm trying to filter a list using the REST service. The column im trying to filter is the default column "Modified". My problem is: I can get all itens created today, but not only the items created ...
1
vote
2answers
203 views
CAML Query List by months
I was wondering if i have 3 random dates.
11/12/2012
9/24/2011
12/29/2008,
I'd like to have
September
9/24/2011
November
11/12/2012
December
12/29/2008
instead of using the query to sort by ...
3
votes
1answer
292 views
Set a date/lookup in ListInstance elements.xml
I have two lists. The first one has customers and the second one has Orders. Now i want to add some (test) data in the elements.xml of the listinstances. For customers this works without a problem
...
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
2answers
126 views
Saving date on sharepoint profile
I have a method on my code that stores the birthday of users on a Sharepoint profile property (BirthDay).
This property only accepts the format "yyyyMMddHHmmss.0Z" so i have the following code:
...
5
votes
2answers
768 views
Why is central admin time different from server time?
I have seen this question asked before (not here) but have never seen anyone with a genuine answer, usually people provide lots of info surrounding how Sharepoint has a different timezome for each ...
2
votes
1answer
627 views
Incorrect Modified Dates on SharePoint Online for clients in other timezones
I've run into a strange problem with SharePoint Online.
When updating or creating entries in a list using the Client Object Model, the modified date on the affected list item seems to be stored with ...
7
votes
4answers
752 views
CAML Now Instead of Today - CAML Bug?
I have a CAML query, in which the <Where> node looks like:
<Where>
<Leq>
<FieldRef Name='PublishedDate'/>
<Value Type='DateTime'>
<Today/>
...
2
votes
1answer
188 views
Why is default ScheduledItem StartDate a 'weird' value?
If you create a new ScheduledItem object and look at the StartDate - it's 1/1/1990 - why? This has just caught me out when trying to evaluate whether the dates have been set or whether they're, what I ...
1
vote
1answer
461 views
Validation of dates in different fields in sharepoint
My question is on validation of dates in SharePoint…
If i have two date fields – start date(& time) and end date(&time). How do i validate these, so that a person cannot pick a time in ...
2
votes
2answers
1k views
Possible to use DateOnly with the DateTimeField control?
I have a DateTimeField control that I would like to only display dates with. I tried setting the DateOnly member to true but when I try to save the page that is using this it throws the following ...
3
votes
2answers
2k views
How to set the Default value of a Date/Time column to next Friday?
I did some poking around in the documentation for Calculated field formulas, but I don't see anything that would help me do this. Does anyone know if it can be done? Can you point me in the right ...
0
votes
1answer
112 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
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
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 ...
1
vote
2answers
144 views
BCS Date Only field on Update Form
I'm tasked with finding a method for Updating a field that is defined as Date in SQL, but rendered as DateTime through BCS (as there is no Date-only type). On the Update form, I only want a Date ...
