MSDN Magazine April 2002
View Complete Post
This is the third part of my three-part series on serialization. In part one, I showed how to serialize and deserialize objects. I also showed how to define types that allow instances of themselves to be serialized.
MSDN Magazine September 2002
MSDN Magazine July 2002
So i was trying to use a calculated column that added 7 days to the start date of a calendar item. The calculated column worked fine because i checked with several tests. Then i tried using the Column as the End Time in the Time Interval Setting in the Calendar View. This broke Sharepoint. Not the normal graceful error im using to seeing from Sharepoint but the Server Error Page when a dump happens in a ASP page. I havent enabled the full error page because i assume its not like i can fix it, i dont have the source code.
Does anyone else experience this? If so is it a known problem and being worked on?
I have a little question about calculated columns in WSS 3.0 (not MOSS 2007)
How can I have a calculated column which is a Date+Time based on a text_column
Converting YYYYMMDD_HHMM (time = 24 hour format) formatÃÂ ==>ÃÂ Date+Time
20070629_0848 converting to 29/06/2007 08:48
==> I have already a formule, but with teh DATE(...) function, you cannot give the hour-minute-seconds as a parameter, so the time is always 00:00 in WSS 3.0 (and yes, i have selected date+time as result-type for the column)
Is this possible in WSS to calculate a full date out of a text, maybe if i use two seperate text-columns, and convert a to date and one to time and a third which combines the two...
It would be a huge help if somebody could give me som advice to calculate a full date+time out of one or more text-columns....
I have a little question about settings specific today (Date + Time) value to a field/column within a workflow that is designed by Sharepoint Designer 2007.
I can manage to set the field to today() => but the time is always 00:00 houres.
I would like toÃÂ set a specific field to the "exact" date+time when the workflow is running. (so choosing a fixed date+fixed Time isn't a solution either)
So I anyone could help me how I can do such "simple" task, I would be very pleased.
I can't find out how to set the format for this column in document libraries. I have seen the column also display time so I know it's possible.
I have a Timestamp column in my Table. I want to read the date time value and display in UI.
In Linq the Timestamp column is represented as System.Data.Linq.Binary.
I dont know how to retirve date time value in "MM-dd-YYYY" format from this Linq.Binary
- Why I am using Timestamp?.
I want to perform some operations based on the last modified date time of the particular row. Since I am using TimeStamp column in my Table as version column, It will contain the last modified date details, So i want to read the date time value from this time stamp column to do some other operations.
I created new column in list - Date and time (Date and time format: Date&Time, Default value: Today's Date)
The problem is, when I create new item in list, the default time is always set as next full hour, eg. now it's 13:15 or 13:31 ora 13:57 and in aspx form it's all the time 14:00. Obviously, I can change that date with 5 minut precision (13:05, 13:10, 13:15
etc.), but it's kind of annoying.
This is probably a simple question but here it goes.
First off let me state that the naming of these columns is not by my choice nor can I change them. We purchased some software that automatically does the naming conventions for it's fields (Sample1).
I have a table with 2 columns in it:
Sample1 Time is in GMT Time
Time DateTime, PK
ABC_Price (Day, Hour) is in EST Time
Day SmallDateTime PK
Hour TinyInt PK
What I need to do is split the Ti
Windows Server 2003, SharePoint Designer 2007, Windows SharePoint Services 3.0
I have a calendar list with start date(datetime1) and end date (datetime2). Each is the default column created by the calendar list in SharePoint. They both display a date and a time to choose from.
QUESTION: Is there a way to remove the date section of the end date in a custom list form so that the user can only pick an end TIME? Or, is there a way to force the end date (datetime2) to HAVE TO BE the same DATE as datetime1,
only allowing for a different time?
I have a requirement in SQL server 2008 as follows:
I need to Insert into a particular table say Output at runtime where one of the columns (Content) of type text should contain an object of another table (Audit). This is currently being done through C# by serializing the Audit table and updating the Content
with the serialized value. But this needs to be done in SQL now as per the requirement.
Can this be done by creating an object of Audit and storing in Output.Content in SQL itself?
Thanks in advance for the help.
when I use 'RowNumber' = ROW_NUMBER() OVER(ORDER BY ColumnName) then due to orderby Column name consume 76% usage. in such case what I have to do? I can see sorting taking much time in execution plan.