Share Improve this answer Follow GETDATE() 30 How to List all Mirrored SQL Server Databases; SQL Date Functions The following table has a list of all the important Date and Time related functions available through SQL. You would want to use >= to get everything between today, sysdate(), and 30 days. You can specify date values or date literals in WHERE clauses to filter SOQL query results. Not the answer you're looking for? Initialize a Dictionary with keys and values in Python, Python - Returning Multiple Values in Function, Python - Check if a value is in Dictionary, Python - Access Nth item in List Of Tuples, MySQL where date greater than 30 days ago. "select A,B where F=date'2010-08-30'". I don't understand what I am doing wrong, why it is not picking those dates up. SpecifcDate__c >=: date. What are possible reasons a sound may be continually clicking (low amplitude, no sudden changes in amplitude). site at https://forums.sqlteam.com. I usually just do it this way and it works, However, for some reason it doesn't work for this table(?). @Pjack: ah, so I did have missed something. I have tried GetDate()-30, Today()-30 but no luck. Search the forums for similar questions We've got lots of great SQL Server experts to answer whatever question you can come up with. Databases Microsoft SQL Server Get dates that are older than 30 dates from today Posted by spicehead-endil on May 23rd, 2022 at 11:42 AM Needs answer Microsoft SQL Server Hello everyone, I have such a situation. Your query is set to obtain records between today (including time) and 30 days previous. Here is what I do: but if add a time, above answers are not working. This section describes what occurs when other date and time data types are converted to the datetime data type. In Azure Cosmos DB, the GetCurrentDateTime system function will return the current UTC date and time ISO 8601 string value in the format: yyyy-MM-ddTHH:mm:ss.fffffffZ. Then compare the Date of the current date and out of Add to time action. If you add a calculated column to your table, yo can write formula like this. Your query is set to obtain records between today (including time) and 30 days previous. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. To provide the best experiences, we use technologies like cookies to store and/or access device information. it will do the conversion for you, but in my opinion it is less readable than explicitly converting to a DateTime for the maintenance programmer that will come after you. start of month, +1 month, and -1 day are the modifiers. These are also "sargable" meaning than an index on orderdatum can be used for the query. Does Postgresql even have a UNIX_TIMESTAMP function? How to check if an SSM2220 IC is authentic and not fake? All other examples seem to use DateTime fields or something. In what context did Garak (ST:DS9) speak of a lie between two truths? Making statements based on opinion; back them up with references or personal experience. How to add double quotes around string and number pattern? How can I do an UPDATE statement with JOIN in SQL Server? (NOT interested in AI answers, please). I am wanting to . To delete records from a table that have a datetime value in Date_column older than 30 days use this query: USE Database_name; DELETE FROM Table_name WHERE Date_column < GETDATE () - 30 .or this: USE Database_name; DELETE FROM Table_name WHERE Date_column < DATEADD (dd,-30,GETDATE ()) If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. SQL. Problem is its returning data from current day if a record from exactly 30 days ago doesnt exist, as well as irrelevant data. Records Greater Than 30 Days Sep 10, 2014. JQL query for issues in a status for longer than 30 days JQL query for issues in a status for longer than 30 days Deleted user May 27, 2021 Can someone help me with a query to pull all stories that have been in a certain status longer than 30 days? For some reason, there are IBLREC's that are 0 instead of a date. What is the type of the, The philosopher who believes in Web Assembly, Improving the copy in the close modal and post notices - 2023 edition, New blog post from our CEO Prashanth: Community is the future of AI. How can I get column names from a table in SQL Server? Why am i getting this error? How to Create a Dictionary from List in Python? I have been unable to figure out the correct formula to use. SELECT from Results WHERE date NOW () - INTERVAL 30 DAY; Delete records older than N days, hours or minutes in SQL Server. Select records using records' column value as interval, Delete records in PostgreSQL, older than X days, where X is a parameter, send us an email after 10 days to the user. Also, are you looking for 30 days from now, i.e. Can someone please tell me what is written on this score? PyQGIS: run two native processing tools in a for loop. How can I drop 15 V down to 3.7 V to drive a motor? To provide the best experiences, we and our partners use technologies like cookies to store and/or access device information. Join our monthly newsletter to be notified about the latest posts. and call the new column "hasissue". To subscribe to this RSS feed, copy and paste this URL into your RSS reader. I am trying to create a SOQL Statement to get data from the last 30 days For example, I would do this on SQL Server by writing: Select * from case where createddate > getdate-30. How can I delete using INNER JOIN with SQL Server? Your date math is looking for less than 30 days old, not more than 30 days old, correct? How is the 'right to healthcare' reconciled with the freedom of medical staff to choose where and when they work? Asking for help, clarification, or responding to other answers. Making statements based on opinion; back them up with references or personal experience. To get dates older than 1 week, you can use the following syntax . How small stars help with planet formation. Discussion: If you would like to subtract dates or times in SQL Server, use the DATEADD () function. Mike Sipser and Wikipedia seem to disagree on Chomsky's normal form. The default field equals to below code: Text (DateAdd (DatePicker1_2.SelectedDate,-30,Days),DateTimeFormat.LongDateTime) That gives me the same format and -30 days, it equals to: "Thursday, February 18, 2021 12:00:00 AM". How can I drop 15 V down to 3.7 V to drive a motor? Didn't find what you were looking for? What could a smart phone still do or not do and what would the screen display be if it was sent back in time 30 years to 1993? it does when I run it against my data (with the table and column names changed). In our example, we use PurchaseDate, a date column. I was planning to setup LAG between the three switches using the SFP ports to b Spring is here, the blossom is out and the sun is (sort-of) Copy to clipboard SELECT * FROM patient_appointment_details WHERE DATE(appointment_date) > ADDDATE(CURDATE(), 30); Output:- image_5 What PHILOSOPHERS understand for intelligence? Enumerate and Explain All the Basic Elements of an SQL Query, Need assistance? Write a query to display the rental number, rental date, video number, movie title, due date, return date, detail fee, and number of days past the due date that the video was returned for each video that was returned after the due date. The last argument is the date were operating on; this could be a date/time/datetime column or any expression that returns a date or time. Not just 1 and 4, and not just 2 and 3. Is there a free software for modeling and graphical visualization crystals with defects? Is there a way to use any communication without a CPU? Hi Experts, (Tenured faculty). GETDATE() didn't work for me using mySQL 8, ERROR 1305 (42000): FUNCTION mydatabase.GETDATE does not exist. Mar 13th, 2015 at 2:46 PM check Best Answer. Sql server query sql delete statement where date is greater than 30 days. SELECT DATEDIFF (month,'2011-03-07' , '2021-06-24'); In this above example, you can find the number of months between the date of starting and ending. Our database has a table named Computer with data in the columns Id, Name, and PurchaseDate. How can I delete using INNER JOIN with SQL Server? rev2023.4.17.43393. Your email address will not be published. Add this to your WHERE line in your sql report/query/view. Can someone please tell me what is written on this score? Do you want to NULL the fields? getdate () returns time also, so in the current case not all records created 30 days ago will be deleted to delete records by days , it's better to use cast to date type example:. Why are parallel perfect intervals avoided in part writing when they are so common in scores? Convert from MySQL datetime to another format with PHP, PHP date() format when inserting into datetime in MySQL, MySQL select rows from exactly 7 days ago, Show events from the last 7 days via MySQL, Selecting records from monday 4 weeks ago, SQL get a last updated DATETIME field from EXACTLY 3 weeks ago, MYSQL select date now-1 day with TIME and between date, Sci-fi episode where children were actually adults. Later, you'll explore common business metrics for nance, customers, employees, and . Site design / logo 2023 Stack Exchange Inc; user contributions licensed under CC BY-SA. This function in SQL Server is used to return the present date and time of the database system in a 'YYYY-MM-DD hh:mm: ss. Is there a free software for modeling and graphical visualization crystals with defects? However, I would like to retrieve any records that have a transaction date greater than 30 days from the disconnect date. How do I UPDATE from a SELECT in SQL Server? Why is Noether's theorem not guaranteed by calculus? Dates represent a specific day or time, while date literals represent a relative range of time, such as last month, this week, or next year. The function returns a changed date. In orientDB, how to search entries for which date are in a given year? (Result shown in Figure 23.) The first argument is the date/time unit in our example, we specify the day unit. You can use the DateAdd function to add or subtract a specified time interval from a date. It should be 3500,9000) WITH UR . Why hasn't the Attorney General investigated Justice Thomas? A single-argument to_timestamp function is also available; it accepts a double precision argument and converts from Unix epoch (seconds since 1970-01-01 00:00:00+00) to timestamp with time zone. BETWEEN includes all values in between the two arguments, including the value at each end. Asking for help, clarification, or responding to other answers. I think what many people don't realize with GETDATE ()-7 is that they're getting a date exactly 168 hours before the current timestamp rather than everything from the beginning of the day 7 days ago. The first query gets everything >= 30 days old. How do two equations multiply left by left equals right by right? Your daily dose of tech news, in brief. To learn more, see our tips on writing great answers. Mike Sipser and Wikipedia seem to disagree on Chomsky's normal form, New external SSD acting up, no eject option. To subscribe to this RSS feed, copy and paste this URL into your RSS reader. Patron Saint of Lost Yaks, Damian39 Launching the CI/CD and R Collectives and community editing features for Add a column with a default value to an existing table in SQL Server, How to return only the Date from a SQL Server DateTime datatype. Databases. Then use this as criteria -- <DateAdd ("d", -90, Date ()) It will list the last donation of individual that was more than 90 days ago. Figure 23 Number of days late 28. WHERE CAST(SL_PL_NL.DETAIL.DET_DATE AS DATE) >= CAST(GETDATE()-7 AS DATE) Adding the minus 7 pulls the current date and time and subtracts seven days. Hope it helps. What does Canada immigration officer mean by "I'm not satisfied that you will leave Canada based on your purpose of visit"? What sort of contractor retrofits kitchen exhaust ducts in the US? experts to answer whatever question you can come up with. (EXTRACT (MONTH FROM Start_Date) - 1) * 30 + EXTRACT (DAY FROM Start_Date) BETWEEN ( (EXTRACT (MONTH FROM CURRENT_DATE) - 1) * 30 + EXTRACT (DAY FROM CURRENT_DATE) - 90) AND ( (EXTRACT (MONTH FROM CURRENT_DATE) - 1) * 30 + EXTRACT (DAY FROM CURRENT_DATE)) and cast(IBLREC as datetime) != '0' bring an error. Asking for help, clarification, or responding to other answers. In SQL, you use the HAVING keyword right after GROUP BY to query the database based on a specified condition. When Tom Bombadil made the One Ring disappear, did he put it into a place that only he had access to? When you want to refer a cell value contains a date. In addition to quotes, I recommend always using a safe and unambiguous format for date-only string literals. select *from yourTableName where yourColumnName < now () - interval 1 week; To understand the above concept, let us create a table. Not the answer you're looking for? The philosopher who believes in Web Assembly, Improving the copy in the close modal and post notices - 2023 edition, New blog post from our CEO Prashanth: Community is the future of AI. For example, if the Specific Date is April 30, then I want the process to continue through May 14. The technical storage or access is strictly necessary for the legitimate purpose of enabling the use of a specific service explicitly requested by the subscriber or user, or for the sole purpose of carrying out the transmission of a communication over an electronic communications network. The SQL used is as . sql query to delete records older than 6 months (6) I wish to find a SQL statement that when executed deletes fields that are older then 30 days. Date greater than current date minus days I want a process (a callout) to continue for 14 days after a specific date. Requirement is when someone from the outside network when tries to access our organization network they should not able to access it. T-SQL Count days between two days (datediff not quite working), Number of products that falls into 'more than 4 days' and 'less than 4 days', Trying to use DATEDIFF() and CURDATE() functions to receive a result of days in SQL, Make inner query to delete duplicated code. By using this site, you agree to our, mysql grant user privileges to database that has suffix and prefix, mysql select where date greater than 1 day, get date as yesterday or today string mysql, mysql select entry with date between now and 15 days, mysql greater than or equal to date and equal to ro less than date, mysql code date greater than current date, mysql select where date greater than 24 hours, mysql where date greater than from other table, how to select data in mysql greater than 6 months, check if date is greater than selected date in mysql, from this date time greater than value in mysql query, select row from mysql where date more than 30 days, mysql command to retrieve data of last 30 days, mysql select where date less than 30 days, mysql dateCreated greater than than 30 days, php mysql select rows where date less than 30 days ago. If the 0's are strings, put the single quotes around the 0's in the statement above, of course. Do EU or UK consumers enjoy consumer rights protections from traders that serve them from abroad? Now I've found a lot of similar SO questions including an old one of mine, but what I'm trying to do is get any record older than 30 days but my table field is unix_timestamp. including hours, minutes, seconds, etc? What is the etymology of the term space-time? The technical storage or access is required to create user profiles to send advertising, or to track the user on a website or across several websites for similar marketing purposes. What are possible reasons a sound may be continually clicking (low amplitude, no sudden changes in amplitude). The time is represented in a 24-hour format. selecting records in mysql db from 1, 7, and 30 days ago with datetime and php, The philosopher who believes in Web Assembly, Improving the copy in the close modal and post notices - 2023 edition, New blog post from our CEO Prashanth: Community is the future of AI. Thanks for contributing an answer to Stack Overflow! In which case, you might consider: To delete records from a table that have a datetime value in Date_column older than 30 days use this query: To delete records from a table that have a datetime value in Date_column older than 12 hours: To delete records from a table that have a datetime value in Date_column older than 15 minutes: The former is not sargable (i.e. Also I highly recommend using YYYYMMDD instead of YYYY-MM-DD. To me it looks like you need to add this to your WHERE clause. I have been unable to figure out the correct formula to use. My table events has a field date that contains the date and the time it was inserted in the database. What kind of tool do I need to change my bottom bracket? What is the etymology of the term space-time? mysql date greater than 30 days Williampli SELECT * FROM my_table WHERE created_at > DATE_SUB (NOW (), INTERVAL 1 DAY) View another examples Add Own solution Log in, to leave a comment 4 7 Xiaodi Li 95 points mysql> delete from DemoTable where UserMessageSentDate < now () - interval 30 DAY; Query OK, 3 rows affected (0.11 sec) Thank you! Is there a similar way to keep this in place with SOQL. Can someone please tell me what is written on this score? @ColinMackay nulling fields might actually be a legitimate thing to do when, for example, anonymizing data. rev2023.4.17.43393. calculate the time difference between start date and end date ; I want to display the result whose time difference is greater than 1 hours. Here you'll need to specify that both are TIME values in order to return the difference in hours: SELECT TIME '11:00' - TIME '3:00' AS time_diff; Output. You will not return rows where the date is 30 days ago and the time is less than 3:00 pm (or whatever time GetDate() returns). How can I drop 15 V down to 3.7 V to drive a motor? Although the DATEADD is probably the most transparrent way of doing this, it is worth noting Stack Overflow - Where Developers Learn, Share, & Build Careers FUNCTION fu_dev.DATEADD does not exist. Not sure.. that might be why its not working.. lol. Not consenting or withdrawing consent, may adversely affect certain features and functions. MySQL query to return all records with a datetime older than 1 week. Connect and share knowledge within a single location that is structured and easy to search. However, 7 What are possible reasons a sound may be continually clicking (low amplitude, no sudden changes in amplitude). SQL statement to retrieve items added in the last 30 days. The time component is set to 00:00:00.000. If you just want dates from the single day that is 30 days ago, try this: Use CURDATE() instead of SYSDATE() because CURDATE() returns a date without a time component. It takes three arguments. That was the problem. Learn how your comment data is processed. How small stars help with planet formation. Could a torque converter be used to couple a prop to a higher RPM piston engine? Compares two expressions for greater than or equal (a comparison operator). Youd like to get the date 30 days before a given date in T-SQL. Queries that filter for null (missing) or non-null dates Examples that use the current date in their criteria Examples that work with a date or range of dates other than the current date Queries that filter for null (missing) or non-null dates Having trouble with date criteria, such as not getting the results you expect? In our example, the query for the computer named 'Dell K80' returns a new date in the BeforePurchaseDate column. Is there a way to use any communication without a CPU? First convert TexBox into the Datetime then.use that variable into the Query, The date format has no issue with me(Mydate's data type is datetime) : The first argument is the date/time unit - in our example, we specify the day unit. How do I escape a single quote in SQL Server? Or 30 days from midnight today (e.g. Content Discovery initiative 4/13 update: Related questions using a Machine SQL Server Datetime newer than specific date, Athena greater than condition in date column, T-SQL filtering by date in dd/mm/yyy format. @AaronBertrand, I had to use your suggestion in conjuction with the above answer: I think it's clear enough that this is a date, and thus conversion is not necessary. As it stands, the query will return students born on July 2, 1992 or later. How can I list all foreign keys referencing a given table in SQL Server? Browse other questions tagged, Where developers & technologists share private knowledge with coworkers, Reach developers & technologists worldwide, Trying to show datediff greater than ten days, The philosopher who believes in Web Assembly, Improving the copy in the close modal and post notices - 2023 edition, New blog post from our CEO Prashanth: Community is the future of AI. Sort the results by rental number and movie title. Asking for help, clarification, or responding to other answers. Connect and share knowledge within a single location that is structured and easy to search. Theorems in set theory that use computability theory tools, and vice versa. (Tenured faculty). The DateAdd function will not return an invalid date. Wouldn't using the getdate function within the formula calculate based on today's date rather than the date values within the tables I'm querying?Damian. <DateField> = DATE 'YYYY-MM-DD'. I think I need to use the datediff function in SQL, but Ive never really used this function before. How do two equations multiply left by left equals right by right? What are the benefits of learning to identify chord types (minor, major, etc) by ear? You need to hear this. By clicking Post Your Answer, you agree to our terms of service, privacy policy and cookie policy. Try enclosing your date into a character string. It would be good to provide a direct link to your source, the specific part of the manual. Find centralized, trusted content and collaborate around the technologies you use most. Piston engine opinion ; back them up with I delete using INNER JOIN SQL. Time ) and 30 days from the outside network when tries to access it question you can the. Date-Only string literals statement above, of course a place that only he had to. Lt ; DateField & gt ; = date & # x27 ; YYYY-MM-DD #... Sound may be continually clicking ( low amplitude, no sudden changes in amplitude ) cookies store. Converter be used to couple a prop to a higher RPM piston engine, use the following syntax that be... Place with SOQL tell me what is written on this score using INNER JOIN with SQL Server DateAdd ( -30! Kind of tool do I escape a single quote in SQL Server table, yo write... To 3.7 V to drive a motor of month, +1 month, and 30.... After GROUP by to query the database column to your WHERE clause not... Example, the query will return students born on July 2, 1992 or later One Ring,... Add double quotes around string and number pattern in the statement above, of course than. Nulling fields might actually be a legitimate thing to do when, for,... This section describes what occurs when other date and the time it was inserted the... How to add or subtract a specified condition in your SQL report/query/view records today... To Create a Dictionary from List in Python you need to add or subtract a specified condition right... To obtain records between today, sysdate ( ), and PurchaseDate I have been unable to out. Items added in the US is April 30, then I want the process to continue for 14 days a! To other answers not interested in AI answers, please ) why are parallel perfect intervals avoided part... Trusted content and collaborate around the 0 's in the statement above of..., why it is not picking those dates up great answers UK consumers consumer! Asking for help, clarification, or responding to other answers @:... Update from a select in SQL Server thing to do when, example... Your query is set to obtain records between today ( including time ) and 30 days a... Statement above, of course medical staff to choose WHERE and when they are so common in scores two! Through may 14 piston engine Answer, you agree to our terms of service, privacy and! Database based on a specified condition single location that is structured and easy to search Id, Name and... More than 30 days from now, i.e easy to search entries for which date are in given. Dateadd ( ) -30, today ( including time ) and 30 days old, correct,. Why has n't the Attorney General investigated Justice Thomas whatever question you use. Function to add this to your WHERE line in your SQL report/query/view terms of service, privacy and. External SSD acting up, no eject option data ( with the freedom of staff! Purchasedate sql query date greater than 30 days a date column perfect intervals avoided in part writing when they are so in... From current day if a record from exactly 30 days and not 1... Argument is the 'right to healthcare ' reconciled with the freedom of medical staff to choose WHERE and they. Dictionary from List in Python but Ive never really used this function before and not just 2 and 3 to... Identify chord types ( minor, major, etc ) by ear days old, correct days ago exist. Purchasedate, a date higher RPM piston engine and 30 days old date-only... Clarification, or responding to other answers design / logo 2023 Stack Exchange ;... Single quotes around the technologies you use the DateAdd sql query date greater than 30 days to add this to WHERE. You agree to our terms of service, privacy policy and cookie policy actually. If add a time, above answers are not working.. lol explore common business metrics for nance customers. Datetime data type a sound may be continually clicking ( low amplitude, no eject option best experiences, use... Latest posts enumerate and Explain all the Basic Elements of an SQL query, need assistance equations multiply left left! I recommend always using a safe and unambiguous format for sql query date greater than 30 days string literals tell what. To continue for 14 days after a specific date day unit new external SSD acting up, no sudden in... ' reconciled with the freedom of medical staff to choose WHERE and when are... Everything between today ( including time ) and 30 days previous amplitude ) the date/time unit in our,. The One Ring disappear, did he put it into a place that only he access! Terms of service, privacy policy and cookie policy = to get everything between today ( time! By `` I 'm not satisfied that you will leave Canada based on opinion ; back them up references... Your Answer, you use the HAVING keyword right after GROUP by to query the.... Be good to provide a direct link to your table, yo can write formula like this in writing. To add or subtract a specified condition monthly newsletter to be notified the! May be continually clicking ( low amplitude, no eject option query, need?! Before a given date in the columns Id, Name, and 30 previous... Safe and unambiguous format for date-only string literals nulling fields might actually be a legitimate thing to do,... Did n't work for me using mySQL 8, ERROR 1305 ( 42000:... Statement WHERE date is April 30, then I want the process to continue for 14 days after specific! Question you can specify date values or date literals in WHERE clauses to filter SOQL query.... Safe and unambiguous format for date-only string literals the date/time unit in sql query date greater than 30 days,. Are in a for loop 4, and vice versa network when tries to access our network... That serve them from abroad Basic Elements of an SQL query, need assistance JOIN. Get column names changed ) dose of tech news, in brief Canada based on opinion ; them. Me what is written on this score JOIN our monthly newsletter to be notified about the latest.. Your date math is looking for less than 30 days ago doesnt exist, as well as irrelevant data,... Consumer rights protections from traders that serve them from abroad drive a motor datetime data.! Guaranteed by calculus software for modeling and graphical visualization crystals with defects between today ( including time and... Date-Only string literals to Answer whatever question you can use the DateAdd ( ) -30 but no luck converter. Changed ) above answers are not working.. lol later, you can come up with month, +1,. Post your Answer, you agree to our terms of service, privacy policy and cookie policy device. I would like to retrieve any records that have a transaction date greater 30! Using YYYYMMDD instead of YYYY-MM-DD YYYYMMDD instead of YYYY-MM-DD data types are converted the. Also, are you looking for 30 days from now, i.e you looking less. Uk consumers enjoy consumer rights protections from traders that serve them from abroad DateField & gt ; = &... I List all foreign keys referencing a given year doesnt exist, as well as irrelevant.... Exchange Inc ; user contributions licensed under CC BY-SA our database has a field date that contains the 30! Date is April 30, then I want a process ( a comparison operator ) enumerate and Explain all Basic... The specific part of the current date and out of add to time action is date/time... I do n't understand what I do n't understand what I am doing wrong why! Having keyword right after GROUP by to query the database based on a specified condition use PurchaseDate, date! Records with a datetime older than 1 week, you agree to our terms of,! And out of add to time action whatever question you can use the HAVING keyword right after by! Also I highly recommend using YYYYMMDD instead of a date column user contributions licensed under BY-SA... Inner JOIN with SQL Server hasissue & quot ; select a, B WHERE F=date & x27! Of learning to identify chord types ( minor, major, etc ) by ear the manual explore common metrics. To check if an SSM2220 IC is authentic and not fake return records! Am doing wrong, why it is not picking those dates up adversely affect certain features and functions for,. Might actually be a legitimate thing to do when, for example, if the specific part the. Addition to quotes, I recommend always using a safe and unambiguous format for date-only string literals on 2! Set theory that use computability theory tools, and Server, use the datediff function SQL... Left by left equals right by right modeling and graphical visualization crystals with defects serve. It against my data ( with the freedom of medical staff to choose WHERE and when they?. Any communication without a CPU quote in SQL Server, use the DateAdd ( sql query date greater than 30 days did work! Well as irrelevant data to subscribe to this RSS feed, copy paste. A torque converter be used for the query for the query will students! Date values or date literals in WHERE clauses to filter SOQL query results into RSS!, not more than 30 days old for loop the date of the current date minus days I want process! That might be why its not working.. lol chord types ( minor, major, etc ) by?. Employees, and not just 2 and 3, Name, and PurchaseDate date in columns.