Topic: calculate the time elapsed in a calculated field
There may be an easier way to do this, but that’s what I was able to create and it works!
(select PRINTF("AMD: %02d %02d %02d", ano,mes,dia) from (
select id,
case when conclusao is null then round((julianday("now") - julianday(inclusao))/365.25-0.5) else
round((julianday("now") - julianday(conclusao))/365.25-0.5) end as ano,
case when conclusao is null then round((julianday("now") - julianday(inclusao)- round((julianday("now")
- julianday(inclusao))/365.25-0.5)*365.25)/30.41-0.5) else round((julianday("now") - julianday(conclusao)-
round((julianday("now") - julianday(conclusao))/365.25-0.5)*365.25)/30.41-0.5) end as mes,
case when conclusao is null then round(round((julianday("now") - julianday(inclusao)-
round((julianday("now") - julianday(inclusao))/365.25-0.5)*365.25))- round((julianday("now") -
julianday(inclusao)- round((julianday("now") - julianday(inclusao))/365.25-0.5)*365.25)/30.41-0.5)*30.41-0.5) else
round(round((julianday("now") - julianday(conclusao)- round((julianday("now") -
julianday(conclusao))/365.25-0.5)*365.25))- round((julianday("now") - julianday(conclusao)-
round((julianday("now") - julianday(conclusao))/365.25-0.5)*365.25)/30.41-0.5)*30.41-0.5) end as dia
from tbl_subtasks) where id = tbl_subtasks.id)