Hi!
I am trying to use duckDB via the "duckplyr" package. I need access to some date logic - for instance the ability to add or subtract 6 months from a date - and do so very accurately (i.e. subtracting 180 days is not sufficient).
I see that duckDB does have support for this - Understanding DATE_ADD() in DuckDB - but I can't see how to use these functions from within duckplyr, despite looking through the documentation and the vignettes.
Any help would be greatly appreciated thanks!
Richard.