sqldf icon indicating copy to clipboard operation
sqldf copied to clipboard

Date issues

Open sarahbaca opened this issue 2 years ago • 0 comments

I had written code that worked fine a few days ago and now sqldf won't do anything with dates. In my dataframe dx_dt is an IDate type and I tried it as a date type with the same result. I'm using R version 4.0.5 which seems to coincided with this change.

sqldf(' select *, cast(min(dx_dt) as date) min_dx from upperbound group by id ') Error in match.fun(asfn) : 'c("as.IDate", "as.Date")' is not a function, character or symbol

sarahbaca avatar May 09 '22 20:05 sarahbaca