[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?