Hi, I have a column (campaign_Date) which stores a DATETIME. Using a Stored Procedure I need to check if the stored date is 90 days old (or more). Any help would be great. Thanks. That's not 90 days before today's date - that's 121 days from over 3 months in the past until 2 days in the future. Do you want a window of TODAY-90 days to TODAY, or something like you've currently got? If the latter, what are the actual rules? So I love listening to 90 Day Cray Cray and 90 Day Gays. I can almost say I enjoy listening to them more than watching the actual show. The consensus from both of those shows after the Ash seminar and ensuing fight was that Ash is a misogynistic gaslighter and Avery should gtfo. Matt from 90 Day Gays even went as far as to say he is scared for Ash’s safety. And he is a clinical psychologist. Learned python in the past 2 days and was wondering if there is a cleaner way to do this.This method works.it just looks ugly and It seems silly to have to create a new time variable for each date, and that there should be a way to offset the given date to the start and end of the week through a simple call but i have been unable to find anything on the internet or documentation that looks. I am attempting to create a FetchXML script that retrieves records with a date of today minus 30 days. Below is the SQL that works. Could somebody help me with the FetchXML, please? SELECT * FROM [ How to add days to current Date using JavaScript? Does JavaScript have a built in function like.NET's AddDay()? The original question was trying add 30 days to a variable date: $date but this solution adds 30 days to the current date. I have the following query to get the last 90 days records from my DB. Sample Data below: my query code: SELECT Email ,Country ,Date_of_Birth ,Date_Added ,Received_ProfileCompletionPromoCode ,Firs. That would give you sales from 90 days ago, not the sum of all sales in the last 90 days. This function computes the number of days between two Calendars as the number of calendar days of the month that are between them, which is what the OP wanted. The calculation is performed by counting how many multiples of 86,400,000 milliseconds are between the calendars after both have been set to midnight of their respective days.