0

About access

how to create a query that show bills have day before 365 days of computer

29th Nov 2017, 2:47 PM
goku nhok
goku nhok - avatar
6 Réponses
+ 1
I'm pretty sure this should work. SELECT * from bills where bill_date >= DATE_SUB(NOW(),INTERVAL 1 YEAR);
2nd Dec 2017, 10:03 AM
Private [GER]
Private [GER] - avatar
+ 1
Access? Are you talking about Microsoft Access?
1st Dec 2017, 11:16 PM
Private [GER]
Private [GER] - avatar
+ 1
In which format are the dates stored?
2nd Dec 2017, 10:02 AM
Private [GER]
Private [GER] - avatar
+ 1
No problem :)
3rd Dec 2017, 8:32 PM
Private [GER]
Private [GER] - avatar
0
yes, sir
2nd Dec 2017, 4:51 AM
goku nhok
goku nhok - avatar
0
ah, ok, thank you very much 😊
3rd Dec 2017, 2:29 PM
goku nhok
goku nhok - avatar