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


Top 5 Contributors of the Month
Shivakumaran
Post New Web Links

how to add the modified date to an entry

Posted By:      Posted Date: November 29, 2010    Points: 0   Category :ASP.Net
 

hello

 I have added a datetime field to my db and added  the default  value  binding to (getutcdate()), (allow null=false)  how can I have  the date/time  added to my db when the user is adding his data ?

 




View Complete Post


More Related Resource Links

Latest Records depending on Last Modified Date

  
Hi there,             I have to get the latest records from the table depending on Last Modified date. Table: ID  Function   Apply        Approved    Withdrawn   LastModifiedDate 1    Coding    1/1/2010   15/1/2010   21/1/2010     21/1/2010 3:58:23 1    Coding    1/1/2010    NULL           NULL           21/1/2010 4:58:23 2    Testing    1/1/2010   15/1/2010   21/1/2010    21/1/2010 3:58:23 3    Analysis  1/1/2010    NULL           NULL           21/1/2010 4:58:23   Output is needed on the basis of last modified date if same fucntion comes more than 1 time. else all other functions need which appears once in table. ID  Function  Apply      Approved    Withdrawn        LastModifiedDate 1    Coding   1/1/2010    

select top row for multiple entry for a date in table

  

My current query is

select  Date= createdon , Total=count(*) from ReportDetail where 
reportid = 9 and (CreatedOn BETWEEN '07/01/2010' AND '09/30/2010') 
group by  createdon
order by createdon desc

return data like

2010-09-21 09:36:46.493    112
2010-09-21 08:33:12.667    114
2010-09-21 07:45:20.830    176
2010-09-21 07:33:34.340    114
2010-09-20 07:27:43.753    125
2010-09-17 10:04:27.120    75
2010-09-16 11:50:05.777    52

What I am looking for

2010-09-21 09:36:46.493    112
2010-09-17 10:04:27.120    75
2010-09-16 11:50:05.777    52

Basically for 9/21, I want to get only one latest row. Please advice.


Last modified by and last modified date changes after doing stsadm export/import

  

After doing an stsadm export/import of a document library, all the document modified dates are changed to current date and modified by changed to the person who did the import. How do I retain the last modified dates and modified by values as in the source library? I know we can preserve metatdata using the Manage content and structure GUI and saving as templates, but anyway to do it via stsadm?

Thanks.


How to get share point Subsite Last Accessed date using Object Model in moss(Not Modified date)

  

Hi Guys,

My task is to check last accessed date to a sub site in share point like "http://asc-hv1-mossvm:4233/murali121". its not depended on particular log in user (so i.e any user is valied except system account).

if anybody have any idea please share with this post.

Thanks in Advance.

 

 


The file 'document name' has been modified by user name on 'date'

  

Hi,

After modifing the document, if the user edit the document properties and save, it shows error like,

The file 'filename' has been modified by 'user name' on 28 Sep 2010 17:21:04 +0530 .

what is this means? how to resolve this, Please guide me. thanks in advance.

 


Last Modified date of the database

  

Hi,

How to find the Last modified date of the whole database (Not the specific table)? Is there any function available? I checked the last modified date of the mdf file and that does not give the correct information :(


Dreaming a world without any war in anywhere

import-spweb changes some values (create date, modified...)

  

Hi,
all my Imported items (export-spweb - >import-spweb) have today's date now.
And the creater is now mydomain\administrator.

Can I fix this somewhere ?
Maybe in a SQL table ?

thanks,
Coyo


Modified date of a View - SQL 2000

  
Hi
 
In SQL Server 2000, is it possible to get the date that a View was last
modified?
 
Thanks
 
Barry
 
 
 

Only date is displayed in modified column. How do I get it to show time also?

  

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.

Anyone?

Henning 


How to display the "Date Modified" property of documents in SharePoint document library

  

Hello,

I'm using MOSS 2007.

Perhaps you already know that the "Modified" column in SharePoint document library is different from the "Date Modified" property of the document.

"Modified" being the SQL property of the object.

As a consequence, when uploading document to document library you don't have the actual modified date of the document. While you can see it opening the document in Explorer View!!

Is there a way to display the actual modified date of documents as a column in SharePoint document library?

 

Thank you.

Regards

Ruben.


-Ruben-

SharePoint Designer Workflow - how to compare the Items if it is modified date is older than 20 days

  

I have a workflow which will keep track of specific meta data selection for a Custom List, as soon as an item gets updated to a specific selection say it as Resolved, I am sending an email to an user.

 

But after this I will need to check for every item in the list that If an item gets resolved and older than 20 days, I will have to move this item to a different list. I can get the resolved item date, store it an variable, but from here I will need to check if the item is older than 20 days and if it is this needs to be moved.

My point is the work-flows will be fired only when an item gets changed or updated, how to keep track of every item in the list and automatically move the older items without any manual intervention.

 

Am I clear in my requirement, if not kindly let me know.


If you have knowledge, let others light their candles in it.

Date Entry - Calendar not showing for all users

  

Hello

 

So on a data entry form I have several fields, one of which is Date. Now I can see a tiny little calendar that then allowed me to click on the required date however no one else in the group can see this, they have to enter the date manually.

 

I have admin rights, where as they do not but I cant see why this would stop such a small thing working...

 

 

any ideas?

 

Thanks.


"Date Modified" not working in Explorer View if document is created in Explorer View

  

Windows 7 SP1 with Webclient (webdav), Office 2010 Professional Plus, connects to a Sharepoint 2010 Document Library, using Explorer View, mapped to a disc drive letter. Document library has check out requirement turned off.

Customers work only in Windows Explorer with Webclient, they dont want to use web interface to Sharepoint.

Information to recreate the problem:

CASE1) Let's say a new docx document is created in Explorer View (in Explorer by  right-click-new Word document). Customer waits couple of minutes, enters and changes the document in Explorer View, and then saves it and closes Word. Result: Column "Date Modified" in Explorer view is unchanged, when it should have been changed. (!)

CASE2) Let's say I created new docx document in Web View (all documents view). Customer waits couple of minutes, enters the same document IN EXPLORER VIEW, changes it and then saves it and closes Word. Result: Column "Date Modified" in Explorer view is CHANGED to the new save time so now it works!

Why is this happening and is there any fix for this. Is this problem of WebDAV or of Sharepoint? It happends with .docx and .xlsx files, and not with .txt files and some othes which work correct when created in Explorer View.

Also when I copy/paste to Explorer View , column Date

Using a CompareValidator to check input is a valid date

  
The CompareValidator can do more than just compare two controls. You can also compare it against several of the main .net data types such as Date, Integer, Double and Currency.

To do this you would set Operator="DataTypeCheck" and instead of setting the ControlToCompare or ValueToCompare attributes as you normally would you use the Type="Date" (or any of the data types I have listed above).

How To Set a Date Format In GridView Using ASP.NET 2.0

  
A very common desire is to set a column of a gridview to display just the month, day and year of a DateTime type. The problem is the by default, the HtmlEncode property of the boundfield attribute (
The problem is that if this field is enabled, you can not pass format information to the boundfield control. That is, if you try the following code, you will not get the desired result.

jQuery Date picker Implementation in ASP.NET

  
I've posted a wrapper ASP.NET around the jQuery.UI Datepickercontrol. This small client side calendar control is compact, looks nice and is very easy to use and I've added it some time back to my control library.

This is primarily an update for the jQuery.ui version, and so I spend a few hours or so cleaning it up which wasn't as easy as it could have been since the API has changed quite drastically from Marc's original implementation. The biggest changes have to do with the theming integration and the resulting explosion of related resources.

If you want to use this component you can check it out a sample and the code here:

How to format datetime & date with century?

  
Execute the following Microsoft SQL Server T-SQL datetime, date and time formatting scripts in Management Studio Query Editor to demonstrate the usage of the multitude of temporal data formats available and the application of date / datetime functions.

http://www.sqlusa.com/bestpractices2005/centurydateformat/
Categories: 
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