We have a data source: Query Results, with two dates per row: CreatedDate and ResolutionDate.
I would like to be able to calculate the number of days between the two dates, I.E.
Cast (( JulianDay(ResolutionDate) - JulianDay(CreatedDate) ) As Integer)
This doesn’t work though, it doesn’t support Cast or JulianDay. Even though these are supported in SQLite…