.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
david stephan
Gaurav Pal
Post New Web Links

Sharepoint attachments with time/date stamp

Posted By:      Posted Date: October 04, 2010    Points: 0   Category :SharePoint

I am not a sharepoint guru, so please feel free to talk to me like I'm a beginner.

We have a web part that allows attachments and the boss wants to time/date stamp the attachments so he knows which one is the most recent. I know this happens with ease in a regular doc library, but not sure how to implement in a simple web part.

Thanks in advance for any advice.

View Complete Post

More Related Resource Links

Should time date stamp on .Asmx file change when project is rebuilt?

I have a web service project. The web service is named Recalc.asmx and it has a code behind file namedRecalc.asmx.vb Now if I make a change to my web service .vb code and then recompile the project, should my Recalc.asmx filebe updated as well? In windows explorer I see that the time date stamp of my Racalc.asmx.vb file changes to the date of the last change.But the time date stamp of the Recalc.asmx file does not change? Why is that? My original thinking was that I would simply need to copy the Recalc.asmx file to the test server. But the date stillshows it's original creation date of 7/1/2010 and not the date of the last rebuild as I was hoping it would do?

how to get the current date and time using sharepoint designer workflows

hi, how to send an email using sharepoint designer workflow when an item equals to end time. How to get the current date and time.I am able to capture the date but not the time  the time is showing as 12:00:00 AM. First i have create an variable  and storing the date and time in that variable and i am comparing the variable value with end time. If both are equal then i want to send an mail to attendees

Droping a time stamp from a date stored in SQL 2008.


I am printing the data from a SQL 20008 column with a data type of "Date" but when I do it adds in 12:00:00AM to the date. If I look in mangament studio no time stamp is being stored in SQL but when I print it I get the date stored in the column but it adds a time. I have tried useing string.format() trying to remove it but it does not (tried using mm/dd/yyyy for the format). How can I prevent the time from being added to the date? I am  not sure if this is something wrong on the DB side or not. If this is not a SQL error and this post belongs somewhere else please move it there and sorry for posting in the wrong section. 

how to create date time event in sharepoint workflow



I want to change the status of a list item one month after its approval. which event should i fire and how do i do it in workflow. any idea.



"Date&Time" column in list - set actual time and sharepoint's proposes wrong hour (eg. 17:00 instea


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.

Date Time issue in Sharepoint Designer workflow



I am trying to format the date in a Sharepoint workflow (using Sharepoint Designer 2007) so that it does not include the time.  Does anyone know how this can be done?


Any help greatly appriciated...



Srikanth Reddy




SharePoint Date Time Control logic for saving and retriving in List


Hi Friends,

     I am Ali, I need to set the SharePoint Date Time Control in my webpart.


1. When i am adding student details in Admission Form, ( Fields like Name, Class, data of birth, Date of Joining ...)

2. at Date Of Joining : here,  SharePoint Date Time Control should show the default date as (Sys date). 

For this i am using this :  

" DateTimeControl1.SelectedDate =DateTime.Now; "

it is working fine.

and For Saving " Date "  in list item From SharePoint Date Time Control i am using this :

listitem1["Date Of Birth"] = DateTimeControl1.SelectedDate.ToShortDateString();


3. When the user retriving the date from particular list, here Date Time Control should show the date, as what date he (student) was added in the list.

for Retriving date from List to SharePoint Date Time Control i am using this as below: But it doe

compare date field in sharepoint designer without considering time



I  set date1 field in sharepoint designer with “set field in current item” action. And in next step I want to compare date1 with another date field. With “if date1 not equal to date2”

although I set  “Date & Time Format” to “Date only”, my problem is sharepoint designer consider time ( although my condition is true ,I think its compare the time of my date field and cant go next step) and I don’t want it. I want to compare date filed only with date,

what should I do, that sharepoint designer only consider Date in Date field in action?

Thanx a lot.

Date and Time Functions in SQLSERVER

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

1 DATEPART Function
2 DATENAME Function
3 DAY, MONTH, and YEAR Functions
5 DATEADD Functions
6 DATEDIFF Function
7 More SQL Server Functions

Data Types - Date and Time in SqlServer

Date and time values can be stored with either the DATETIME or SMALLDATETIME data type. The difference between the two is that SMALLDATETIME supports a smaller range of dates and does not give the same level of precision when accounting for time. The DATETIME data type can hold values from January 1st of 1753 to December 31st of 9999. The time is stored to the 1 three hundredths of a second and each value takes up 8 bytes of storage. The SMALLDATETIME data type can hold values between January 1st 1900 and June 6th of 2079. The time is tracked to the minute and each value takes up 4 bytes of storage. The majority of business applications can live happily with SMALLDATETIME, however, if you are in an environment where each second matters or you need to make estimates to the distant future (or past) then you have to resort to DATETIME. If you fail to specify the time when inserting a value into a DATETIME or SMALLDATETIME column, a default of midnight is used. If you fail to specify the date portion the default of January 1, 1900 is used.

Built-in Functions - Date and Time Functions

Date and time functions allow you to manipulate columns and variables with DATETIME and SMALLDATETIME data types.

Essential SQL Server Date, Time and DateTime Functions

The essential date and time functions that every SQL Server database should have to ensure that you can easily manipulate dates and times without the need for any formatting considerations at all.

Date/Time Conversions Using SQL Server

There are many instances when dates and times don't show up at your doorstep in the format you'd like it to be, nor does the output of a query fit the needs of the people viewing it. One option is to format the data in the application itself. Another option is to use the built-in functions SQL Server provides to format the date string for you.

Date and Time Data Types and Functions

The following sections in this topic provide an overview of all Transact-SQL date and time data types and functions. For information and examples that are common to date and time data types and functions

reserving time on sharepoint 2007 calendar

HI all,
 I need to have a sharepoint calendar where if I reserve a time that is being used from 12pm-2pm, another person/ same person can't come in and reserve the same time from 1pm-2pm  or 12pm -2pm for the same day. Is there an easy way to do this?

File Attachments from info-path forms to Sharepoint document library


Hi Experts,

How to upload file attachements from info-path forms to Sharepoint document library?

I need to add attachement from local-PC/Any User to Sharepoint Document Library.


Any help please?? Appreciated




Converting UTC to another Time... in XSLT SharePoint designer using ddwrt


I am not a programmer, nor do I know any coding languages.  I have a slightly above average understanding of how writing code works, so please keep that in mind when responding.... 

I am using a list in SharePoint; when the list is updated, I want to display "UPDATED w/ Date and Time".  I cannot figure out how to display the Local Afghanistan time vice UTC or Zulu time. I am trying to figure out what to add in to change the time displayed +4:30 hours.  I am currently using the following code in XSLT with SharePoint Designer:

<xsl:if test="ddwrt:FormatDate(string(@Modified), number(1033), 1)=ddwrt:FormatDate(ddwrt:TodayIso(), number(1033), 1)">

   <xsl:if test="ddwrt:FormatDate(string(@Modified), number(1033), 1)!=ddwrt:FormatDate(string(@Created), number(1033), 1)">

   <Span style="background-color:maroon;color:white">UPDATED <xsl:value-of disable-output-escaping="no" select="@Modified" /></span>



ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend