+ 1

I want to filter on data using where clause on column startdate earlier than 10 months ago from March 2021

How should I write where clause which satisfy above condition please help..šŸ™šŸ¼.

8th Apr 2022, 8:13 AM
Aditya
7 Answers
+ 1
What did you try and why do you think it should work? What are your observations and why do you think it didn't work?
10th Apr 2022, 2:41 PM
Mustafa A
Mustafa A - avatar
+ 1
Aditya It's difficult to say without seeing the database and data types. Also the intervall you tried looks weird. Both of them are lower bound without upper limit. Try this. https://stackoverflow.com/questions/65841023/sql-between-date-range-on-string-date
12th Apr 2022, 8:44 AM
Mustafa A
Mustafa A - avatar
+ 1
Aditya Sorry, I don't have time and I can't use that without an account (I don't create accounts I don't need). The link I shared should solve your problem.
12th Apr 2022, 9:34 AM
Mustafa A
Mustafa A - avatar
0
Hi Mustafa A I tried this where filter but it doesn't seems to work Where signup_start_date >= '2020-05-01' and signup_start_date >= '2021-02-28' Please help me out on it..
12th Apr 2022, 5:45 AM
Aditya
0
platform.stratascratch.com/coding/2031-transactions-by-billing-method-and-signup-id?python= Link to the question
12th Apr 2022, 5:46 AM
Aditya
12th Apr 2022, 9:32 AM
Aditya
0
Thanks Mustafa A
12th Apr 2022, 9:36 AM
Aditya