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

learn more… | top users | synonyms

6
votes
3answers
4k 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
8k 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
1k 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. ...
2
votes
2answers
949 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
918 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
440 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
414 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
5k 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
3k 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
399 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
312 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
2k 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
275 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
65 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
788 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
154 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 ...
12
votes
2answers
13k 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
5k 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 ...