Search results for query: *

Thank you! That works perfectly!!!

Hi Everyone, I am using datename(quarter,getdate()) in order to find the current fiscal quarter. Is there an easy way to get the first and last dates in the current quarter? For example, if today is 8/6/09, then the first date in the quarter would be 7/1/09 and the last date would be...

Thanks to both of you. That is EXACTLY what I needed.

Hi there, I am processing a table which has been populated over the years with invalid dates in the date fields - don't ask me how. Things like 9/31/2006 and stuff like that. Does anybody know of a select statement that could return a list of the rows with bad dates? Something like: select...

It is not my webpage - I cannot edit the code. It is an external website that I want to link to. Sorry, I should have been clearer. Is it possible? Thank you! Joseph

Hi everyone, Do you know if it is possible to call a Javascript function from a browser URL? There is a page which I'd like to call and automatically press a submit button after entering a value. In other words, instead of going to http://www.test.com/test.asp, entering "hi" and pressing...

Hi everyone, I need a formula that will return the date of the first day of the month three months ago. So, if this is January, I would need October 1, 2007 to be returned. I'm trying to do this, but it gives me an error: select Month(CurrentDate) case 3 : Date(Year(CurrentDate)-1,12,1)...

Hi Everyone, For ASP-based websites I usually create a login screen and then save the username in a cookie. However, my current project requires Active Directory authentication when the user first goes to the website. So they enter username and password. Taking them to a login page after...

Hmmm. I hadn't thought about that. I'll flag those in the future. I've gotten good responses in the past...

Hi everyone, I have a form which submits several fields to another page. This 2nd page then inputs the values into a SQL table. The problem I've run into is that if I use some characters, like a single quote in one of the fields, the SQL will break. I understand why that happens, but how...

After checking further it happens in other applications as well. Restarting doesn't seem to help. Can the clipboard have gotten messed up? What kind of insidious thing were you thinking? :) JD

My Excel program started acting funny on Friday. When I go to copy a cell or cells, it slows down really slow, and takes 10 to 15 seconds to complete the process. Then if I paste, it takes another 10 to 15 seconds to do that. I can edit cells, delete and add rows and columns, and do...

Thank you! That was it! Some of our remote users didn't have the patch...

Hi Everyone, Does anybody know what we can do on a 2003 Terminal Server which keeps changing the time every time somebody logs in? Apparently it has something to do with the Daylight Savings issue. Maybe some of the people logging in have 2000 machines... Either way, what happens is that...

Here is the correct attachment.http://www.faith21.org/Test.zip

Help! I seem to be in over my head... I'm just a beginner with Ajax, and I cannot figure out how to call a function on the loading page from an IFRAME within that page. For example, from a button. Look at the attachment to see what I mean. There are two buttons, one of them works, the other...

Thank you! The suggestions from lbass were what I was looking for, but it turned out that I couldn't use the evaluations I wanted to in the formula, so I had to use what dgillz put down! Thanks again!

Hi, I set up a running total to summarize a field. It should be evaluated on change of the group. But not always, only if a certain criteria is met. It seems that I can EITHER use a formula as to when I want to evaluate, OR evaluate when the group changes. Is there any way to use a...

Hi, I have a large Excel spreadsheet with 50,000+ rows. At the bottom of each column, I would like to put the number of cells in that column that were not blank. Can't seem to figure out what kind of function to use... Any ideas? Thanks! Joseph

Hi everyone, I work with others on a terminal server and I'm tired of people installing little utilities and crap that slows the terminal server down. Also, the hard drive space gets low when people download stuff to their desktops. Does anybody know if you can somehow put the following...