0 Replies Latest reply: Oct 13, 2015 4:46 AM by youssef belloum RSS

    Intervalmatch to replace the missing dates with a value

    youssef belloum

      Hi guys, this is my second time here


      Please help me find a solution to my problem.


      I have a table that contains the following fields:




      sct_sim=year cost

      periode.date=date cost



      I need to insert the cost for each date of the month, from first to last day, with the value of the cost "sct_cst_tot" that is already inserted.


      For example here: there is cost inserted "sct_cst_tot" for the date 09/10/2008, I just want to insert that value "9,555" for all days of the month 10/2008.


      I think it is possible with the intervalmatch function,


      Thank you.