@LuongChristian2 In the 1.6 version you can make a 'select count(*)'. Current date: CURRENT_DATE. To add -1 days:
select * from db.TABLE
where DateField < dateadd(DAYOFYEAR, CURRENT_DATE(), -1 )
So retro cool! Win the quad-signed #ThinkDifferentChallenge Apple PIIe - a RaspPi system in an Apple //e case, created as a proof of concept by 🇬🇧Perifractic aka @chrisimpsonline for enhancement by 🇺🇲#The8BitGuy 🇨🇦@MindFlareRetro & 🇩🇪@theJanBeta! https://t.co/1LjESQRQI0
So retro cool! Win the quad-signed #ThinkDifferentChallenge Apple PIIe - a RaspPi system in an Apple //e case, created as a proof of concept by 🇬🇧Perifractic aka @chrisimpsonline for enhancement by 🇺🇲#The8BitGuy 🇨🇦@MindFlareRetro & 🇩🇪@theJanBeta! https://t.co/1LjESQRQI0