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

Question

How should I write where clause which satisfy above condition please help..🙏🏼.

Answer 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?

Answer 2

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

Answer 3

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.

Answer 4

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..

Answer 5

platform.stratascratch.com/coding/2031-transactions-by-billing-method-and-signup-id?python=

Link to the question

Answer 6

Mustafa A here is database and question please help me out if you got any free time

https://platform.stratascratch.com/coding/2031-transactions-by-billing-method-and-signup-id?JUMP_LINK__&&__python__&&__JUMP_LINK=

Answer 7

Thanks Mustafa A