emacs-orgmode
[Top][All Lists]
Advanced

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: One thing each 3 days but maximum 10


From: Quiliro Ordóñez
Subject: Re: One thing each 3 days but maximum 10
Date: Mon, 31 Oct 2022 10:01:09 +0000

El 2022-10-30 23:57, Jean Louis escribió:
> * Renato Pontefice <renato.pontefice@gmail.com> [2022-10-30 19:11]:
>> I have to take a pill each 3 days, but for max 10 times.
>> So I set a TODO pill >2022-10-28 +3d> and each 3 days my calendar tell me 
>> that I have to take the pill. But is possible to say 1/10; 2/10; 3/10 etc?
>> I nean to show how many pill I have already take?
> 
> Use PostgreSQL to give you schedule:
> 
> #+BEGIN_SRC sql :engine postgresql :results value raw 
> SELECT '** TODO Take pill again
>   SCHEDULED: <' || generate_series('2022-10-28', '2022-11-26', '3
> day'::interval)::date || E'>\n'
>   AS "* My treatement";
> #+END_SRC
> 
> #+RESULTS:
> * My treatement
> ** TODO Take pill again
>   SCHEDULED: <2022-10-28>
> 
> ** TODO Take pill again
>   SCHEDULED: <2022-10-31>
> 
> ** TODO Take pill again
>   SCHEDULED: <2022-11-03>
> 
> ** TODO Take pill again
>   SCHEDULED: <2022-11-06>
> 
> ** TODO Take pill again
>   SCHEDULED: <2022-11-09>
> 
> ** TODO Take pill again
>   SCHEDULED: <2022-11-12>
> 
> ** TODO Take pill again
>   SCHEDULED: <2022-11-15>
> 
> ** TODO Take pill again
>   SCHEDULED: <2022-11-18>
> 
> ** TODO Take pill again
>   SCHEDULED: <2022-11-21>
> 
> ** TODO Take pill again
>   SCHEDULED: <2022-11-24>


Isn't it much easier to copy the first one and change the day, instead
of going through the learning curve of database administration?  Of
course that, if you have a bazooka, you can even write a love letter
with it.  But would it be right tool?



reply via email to

[Prev in Thread] Current Thread [Next in Thread]