Bonsoir,

J'aurais proposé


FIRST_VALUE (DATE) OVER (PARTITION BY PERIOD) fv,
LAST_VALUE (DATE) OVER (PARTITION BY PERIOD) lv


mais, en lisant ceci