Search results for query: *

George, Almost. The way the application is setup is that there are 3 columns dealing with the duration of an incident: DateCreated - datetime TodaysDate - datetime DaysOpen - numeric What I am trying to accomplish is to have the database conduct some sort of refresh daily that will allow the...

Ok, I was able to get the TodaysDate to populate when a new record is added with the current date using the default value or binding field in the columns properties. However, what I need is to have that date change daily until the issue is closed. Thus I was thinking that I would need to...

Oh! Now I remember why I wanted to have that date. My delema was that if I coded the TodaysDate dynamically obtaining it through the query code then I wouldn't be able to store the historical data in reference to the number of days an incident was opened. The way the application is setup is...

Thank you both for your comments. I can't beleive that I didn't think of that (since I have used this in the past in previous code). I think I need to leave early today... Kind Regards, Tim

Hello, Is there a way to write a job that would insert the current date into a column from a table? I am attempting to create a KPI (Key Perfmance Indicator) for Management through the use of SharePoint 2007 and one of the indicator field is the difference between the date a help desk call was...

Beowulf005 and Ed, Ok, as it has been discussed in many forums the main thing lacking in this functionality is the ability to have the current date be incrememented +1 for every day it is open dynamically. Currently the forumula is written to equate the difference between the create date...

YES!!! ;) As I suspected it was a matter of being in the right spot. As I look down the list of options in creating the column, I didn't look far enough down the list to see calculated in the top list. I was looking down at the buttom of this configuration panel under default data type. I...

Here is the setup of the three columns in use: Today - default (as per instructed) Date - date/time format (date only) Days - number - calculated value with the following formula in the box just below: =IF([SubDate]="","",(DATEDIF(Today,[SubDate],"D"))) I get an error indicating that The...

Ed, Can you tell me what version of MOSS you are using? I still get an error indicating that the value entered is not a number. If you are using MOSS 2007(V3.0) can you confirm for me that I am entering the formula in the correct box? Thank you again for your help. Tim

BeoWulf005 and Ed, Thank you both for your comments. My first question is, in MOSS2007 is there a special area to enter the actual formula? In MOSS2003 you were able to enter formulas in an advanced options panel but in MOSS2007 it appears that this panel no longer exists. There is a small...

Hello, I am creating a custom list that contains some information of when a customer call is recieved and completed. What I want to do is to create a column that contains the number of days that the call has been in the system unresolved. I have a date entered in the system field and a date...

zencalc, Can you tell me where you were able to locate this filter in your antivirus program. I have McAfee but haven't located where the file filter is. My alerts were working for an entire week but when I returned on Monday, they had stopped. This is driving me crazy. Thanks for any...

The box is checked next to the db I need and I have dbo rights ro the db as well. That is what is so strange. All of this came about because in SharePoint you need to allow users to sign up for "Alerts" on document library's. The problem is that the alerts are not being distributed. Sp is...

If I go into the SQL2005 db and select Security -> Logins -> [My account] -> User mappings: I can see that the DB has dbo in the user column and the schema column. This cannot be changed to my account and shouldn't need to be since I am the dbo. I guess my confusion is that since the server...

I have used domain\uid as well. The odd thing is that if I go to the View Server Permissions, I can see my login under the login/roles table. I can only figure that if you are using Win authentication that the system will not allow you to enter in individual users. Any clarification would be...

Can someone help me out with a permission issue? I have a service that is running SharePoint Timer Service that is using my system account (which has admin priviledges) for startup. This works just fine. In my SQL2005 server I have a DB that must grant permissions to this account. My SQL2005...

I have the wierdest thing happending on my WSS v3 site. For some reason the User Alerts are not getting sent. I checked and re-checked the outgoing email settings and they are fine. If a user chooses "Alert Me" form the document pulldown, they get a confirmation email from SP. But for some...

Phil, Thank you for your advice. I managed to remove all the table and I am now getting a different error. Basically what is happening is that SharePoint wanted me to clear out the search table before enabling the search function. Now SP is throwing an error: The specified database has an...

CAn someone tell me how to script a bulk table drop within a database? I have to delete some 20 odd tables in a database and I don't want to have to do it manually with individual mouse clicks. ;) Thanks

Jammer, The variables are as follows: fromDate toDate HTH. Tim