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

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

Modified date of a View - SQL 2000

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server
In SQL Server 2000, is it possible to get the date that a View was last

View Complete Post

More Related Resource Links

"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

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    

Calculated date field displays differently in List View and Data View web parts

In SharePoint GUI I created a simple custom list with a calculated Date/Time field (Due).  The calculation is =[Created]+7.  I'm trying to display this data on a page using a DVWP.  But first, for testing purposes, I also created a second calculated Date/Time (TestCreate) field in my custom list that is simply =[Created]. In the List View from within SharePoint, the dates show as expected (for example): Created = 8/12/2010 3:45 PM Due = 8/19/2010 3:45 PM TestCreate = 8/12/2010 3:45 PM In SharePoint Designer, I added a Data View web part and the above three data elements (each configured to display mm/dd/yyyy hh:mm:ss tt).  I see the time displayed for the example list item as: Created = 8/12/2010 3:45:30 PM Due = 8/19/2010 10:45:00 AM TestCreate = 8/12/2010 10:45:00 AM I've tested a couple scenarios and the calculated fields always display five hours in the past (along with dropping the seconds).  It seems like the DVWP is returning the date in a different time zone (with no seconds).  The lcid is set right (1033).  I didn't see any time zone settings for the DVWP specifically.  I'm basically stuck.  Could someone help me figure this one out. Thanks.

How to get "Current Date" on SharePoint Designer for Invoice Ageing Data View Report??

Hi Experts, I would like to know how can i get/show "Current Date" in SharePoint Designer ?? Any good tutorial ? FYI, I need this "Current Date" for my Ageing Data View Report, Purpose To offset with "Invoice Receive Date" to get total days of payment payable for the invoice. Please assists, Thanks

How to Add "Modified On" to my Table and View Listings (SQL 2008)

There is a "Create Date" - but I want to know when the last "Modify" date is in both Tables and Views.  is this even doable?  I think it was in SQL 2005RICHARDG

Sharepoint Designer 2010 modified view breaks "hyperlinks" column and formats all hyperlinks to the

I have been trying to perform a simple task with sharepoint designer 2010 that keeps breaking one of my list colums (in the custom view that is).  Background:  I have a list that we are using to assist with Document control in our organization.  The list consists of a few columns: Document number, Title, Owner, Doc Type, and file link (hyperlink to a pdf).  When I create a new out of the box standard view, everything works as desired.  However, I need to adjust the column widths on a couple columns in SharePoint designer, which seems to break the file link column functionality (all of the hyperlinks are now formatted to go to the same document, thought the file paths in each list item are correct).  Funtionality of the file links column works perfectly, until I make a single change to the view in SharePoint designer and save.  Any insight on this issue would be greatly appriciated.  

To Pass date in view at runtime!! Can anyone help Very Urgent

Hey I have to pass the Bussiness date in my query at run time I have tried the query below but not able to Execute it. Select * from table name where and RT.BUSINESS_DATE = ? --if only one date --if between two dates and RT.BUSINESS_DATE Between ? and ? Can Any one help me with the Syntax. Will be greatfull!!!

how do it i created a Grid view that contain onecoloum Expiredate a i require the date compare to


i created a Grid view that contain onecoloum Expiredate a  i require the date compare to today date if it is

  Todaydate<=Expiredate (difference 30 days then color is red
  Todaydate<=Expiredate (difference 15 days then color is blue
  Todaydate<=Expiredate (difference 5 days then color is yellow
    id Expire date  Filename
    1  22/08/10      a(Red )   
    2  22/09/10     b(yellow )
    3  8/09/10      c(green  )
    how do it

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?


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'



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.


format date in data view




How do i convert date which is entered in mm/dd/yyyy format to dd-AUG-yyyy format in data view?Is there an xslt code for it?


Thank you.

Last Modified date of the database



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...)


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 ?


Insert the date as a hidden field using details view


When adding a new record. I have a field that displays the current date using now(). I want to make that a hidden field and simply insert it into the database when the new record is submitted.

I tried making it a template field and then deleting the textbox and inserting a hidden field but I can only either bind it to the field in the database or use custom binding to add the date value 'now()'... I don't seam to be able to do both.

any ideas ?

Is there a way to find out who modified a certain view



I have a list that is open to the company, but someone keeps changing the "all items" view to suit their specific needs.  Is there a way to track who is making changes to the "all items" view?


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.



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