• Registered: 2018-07-14
  • Posts: 34

Topic: SQL Query filter by Month & Day

Button ACTION SQL Query


select id,Prénom,nom,strftime('%m-%d',birthdate)
                                                                                                         
FROM Donnateurs   
                                                         
where  date(birthdate) >= Date({datetimepicker1})
  and  date(birthdate) <=  Date({datetimepicker2})

OK for year, month, day

I need an example how to filter by ONLY month , day (result in tablegrid)

Regards,

2 Reply by tcoton (edited by tcoton 2019-03-12 16:30:08)

  • Registered: 2014-06-25
  • Posts: 861

Re: SQL Query filter by Month & Day

Have you tried this?:


select id,Prénom,nom,strftime('%m-%d',birthdate) as Birthdate
                                                                                                         
FROM Donnateurs   
                                                         
where  strftime('%m-%d',birthdate) >= strftime('%m-%d',{datetimepicker1})
  and  strftime('%m-%d',birthdate) <=  strftime('%m-%d',{datetimepicker2})

  • Registered: 2018-07-14
  • Posts: 34

Re: SQL Query filter by Month & Day

Great !!!

Regards,