3 Replies Latest reply: Jan 24, 2014 1:06 PM by Kevin Maroney RSS

    Script Creation

    Kevin Maroney

      Hey I have a file that has conversion ratios up to a certain date. But I am joining these on to another table with just a date range that matches the invoice dates.

       

      I would like to have all the dates past my conversion ratio to be the last conversion made rather than null. I've attached a test example.

       

      Thanks,

      Kevin