Hi Red, Thanks a lot for your inspiring work - especially for detailed articles!
I'm trying to run BQL query for your article: SELECT account, max(date) FROM #balances WHERE account ~ "^Assets:.*Bank" GROUP BY account But I get error: Unknown token: LexToken(error,'#balances WHERE account ~ "^Assets:.*Bank" GROUP BY account',1,31) I use beancount 2.3.5 for now and bean-query supplied with it. Do you use another version of bean-query? On Tuesday, August 29, 2023 at 7:39:21 AM UTC+3 Red S wrote: > It is helpful to know what accounts you haven’t updated in a while in your > journal. bean-download is a downloader > <https://reds-rants.netlify.app/personal-finance/direct-downloads/> that > ships with beancount-reds-importers > <https://github.com/redstreet/beancount_reds_importers>. It now has a new > feature: bean-download needs-update shows a list of accounts needing > updates, and the date of the last update (which is defined as the date of > the last balance assertion on the account). > > Installation: pip3 install beancount-reds-importers. > > You can filter accounts via its configuration. It handles commodity leaf > accounts. > > *Full article is here > <https://reds-rants.netlify.app/personal-finance/how-up-to-date-are-my-accounts/>.* > > Example output: > $ bean-download needs-update Last Updated Account -------------- > --------------------------------------------------------- 2023-07-22 > Assets:Banks:MainOne 2023-02-05 > Assets:Gift-Cards-and-Credits:Amazon-com-Gift-Cards > > -- You received this message because you are subscribed to the Google Groups "Beancount" group. To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/3639a46a-08bd-4720-94c2-cae6e6e218dcn%40googlegroups.com.