The date-time tag has no wiki summary.
1
vote
3answers
2k 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
369 views
Converting datetime column value to server datetime value
I am trying to build a calendar with date time columns. My SP 2007 server is in US and I am trying to use this site in India. My server returns the EventDate column value in India format. I want to ...
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 ...
0
votes
2answers
724 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: ...
2
votes
1answer
626 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 ...
0
votes
3answers
3k views
SPServices <today /> not returning correct results
This is the chunch of code that I am working with. I am trying to get only the events (normal/all day/recurring) to show, and it is returning all items for the whole week. Any ideas?
...
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
2answers
795 views
How to set date field to Today's Date in Wss 3.0 Custom list form programatically
How can i pre-populate newitem.aspx form with today's date. When user adds new item i want to prepopulate date field with todays date.
<SharePoint:DateTimeControl ID="dtcDateofInsp" ...
3
votes
4answers
787 views
Get SharePoint Server datetime
I was working on a functionality where we had to fetch list items from server using ECMA script (SharePoint 2010 Client Object Model) based on current datetime. The problem is that the datetime we ...
3
votes
1answer
181 views
“Changed On/Modified” columns - Date Format & Regional Settings
I was wondering if I change my regional settings through: Site Settings - Regional Settings - Locale: Dutch (Netherlands), affects the date format of the standard columns (Changed On/Modified e.g.).
...
1
vote
2answers
2k views
setting current date time in sharepoint form field (newform.aspx) sharepoint 2010
I am working on customizing the sharepoint list form (newform.aspx). So soon as the user opens the new form I want the Odate coloumn (date and time) to be filled automatically with the current date ...
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 ...
5
votes
3answers
2k views
Caml to get today's birthdays
I have a list with birthday field (DateTime).
How do I write caml query to retrieve only the records where birthday falls on today (i.e. only comparing day and month value of birthday column to ...
4
votes
4answers
4k views
CAML query not working
I have written following CAML query to Retrieve items which are due in 7 days, It doesn't seems to be working, Please let me know what I missed ?
string internalEndDate = web.Lists["List ...
4
votes
2answers
536 views
DateTime list column with 1 minute increments
How can I change the time portion of a date time column to have 1 minute increments? When you create a coulmn by default it shows 5 minute increments, but I need to be able to use 1 minute increments. ...
1
vote
2answers
703 views
Filter an External List on a datetime Field
So I have an external list in SharePoint 2010 that connects to a SQL database and pulls the data successfully. I also have 2 filters defined along with a limiting (TOP) filter. The first filter is ...
1
vote
2answers
611 views
SharePoint Designer: CurrentDate CAMLVariable is incorrect to compare to date column
I am creating a simple form by "Insert Data View" web part and filtering on the data source by date.
Something like: Displays all the announcement items that have:
"Expires" Greater Than Or Equal ...
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 ...
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
...
1
vote
1answer
2k views
Add a last modified date column for each row in Sharepoint 2010 list
I have a list where I have some columns, my requirement is that I need to add a column, which will update the last modified date for each row.
That is if I edit one row today, add today's date to ...
2
votes
2answers
2k views
Assigning Today() on a DateOnlyType field on InfoPath 2010
I made an InfoPath 2010 form using a SharePoint list template. The SharePoint list has a ReceivedDate field of DateOnlyType which I would like to set using the today() or now() on a "Set a field's" ...
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 ...
1
vote
1answer
256 views
sharepoint designer - collect data from task - date and time
I'm using sharePoint designer 2010,
I have creted workflow.
I used the task "Collect Data From User", and I defined field as "date and time" type.
the user filling the task field and I can see the ...
2
votes
2answers
1k views
How do I format the Custom Field DateTime?
I want to create a date input box. When you select a date, it puts it in the format dd/mm/yyyy using the following Custom Field.
<Field ID="{3a521b04-fca1-4707-9134-fa4acd1456d8}" ...
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
1answer
57 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?
1
vote
2answers
534 views
MOSS 2007 - Filter calendar to display currently running event
I want to create a view for a calendar. The view must display only currently running events.
Right now, I can create a view that filter on for daily event : I currently filter events with Start Date ...
1
vote
2answers
143 views
Calculating event lengths that cross time changes
I have a calculated field to work out the length of an event in days, as follows:
=DATEDIF([Start Time],[End Time],"d")
I live in the UK and we're currently on BST; so if I create an event in GMT ...
9
votes
2answers
7k views
Safest way to get a date from Sharepoint into a C# datetime field, using object model?
If I have a Sharepoint list item with a date field.
How can I get the field value populated into a c# datetime object?
For example:
DateTime validfrom = Convert.ToDateTime(item["validfrom"]);
...
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 ...
