<html dir="ltr"><head></head>
<body style="text-align:left; direction:ltr;"><div>On Fri, 2022-01-28 at 18:55 +0200, Liviu Chircu wrote:</div><blockquote type="cite" style="margin:0 0 0 .8ex; border-left:2px #729fcf solid;padding-left:1ex"><div>Hi Kingsley,</div><div>The 3.1 release is the final release using the classic timerec support. Since 3.2, the time recurrence parsing and evaluation is much more consistent and well-tested across all modules using this concept.</div><div>Still, in order to fix your issue on 3.1, the format I linked is the ONLY way in order to define an [A, B) interval, where B is non-inclusive. Looking at your examples, both strings seem wrong ("20220124T000000|404999" and "20220128T163000|504096247"), because of the poorly formatted DURATION field -- the second one. Example correct strings for that field: P7W (7 weeks), PT24H (24 hours), PT1M30S (1 minute 30 seconds), etc.. The official format is detailed here[1]. Fun fact: MySQL's Galera engine uses this exact format as well, in order to represent time durations in its config file.</div><div>[1]: <a href="https://datatracker.ietf.org/doc/html/rfc5545#section-3.3.6">https://datatracker.ietf.org/doc/html/rfc5545#section-3.3.6</a></div><div>Hope this helps,</div></blockquote><div><br></div><div>Wow yes thank you! I've been trying to get this to work on and off for weeks!</div><div><br></div><div>This did the trick:</div><div><br></div><pre>+--------+---------+--------------+-----------------------------------+----------+---------+--------+----------+--------------+--------------+-------------+</pre><pre>| ruleid | groupid | prefix | timerec | priority | routeid | gwlist | sort_alg | sort_profile | attrs | description |</pre><pre>+--------+---------+--------------+-----------------------------------+----------+---------+--------+----------+--------------+--------------+-------------+</pre><pre>| 200 | 0 | 441476292509 | 20220124T000000|P4DT17H22M | 1 | NULL | #gw9 | N | NULL | endpoint=gw9 | NULL |</pre><pre>| 201 | 0 | 441476292509 | 20220128T172200|PT1M | 1 | NULL | #gw1 | N | NULL | endpoint=gw1 | NULL |</pre><pre>| 202 | 0 | 441476292509 | 20220128T172300|P7101W3DT6H28M15S | 1 | NULL | #gw9 | N | NULL | endpoint=gw9 | NULL |</pre><pre>+--------+---------+--------------+-----------------------------------+----------+---------+--------+----------+--------------+--------------+-------------+</pre><div><br></div><div>I can stop pulling my hair out and cancel the order for that wig ... ;)</div><div><br></div><div>Cheers,</div><div>Kingsley.</div></body></html>