Recent content by Yerdon

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