title: Current Financial Year to sysdate
body: <p>I can't seem to find a straightforward sql without delving into PL SQL for always bringing current financial year in which case 01-04-2015 to sysdate. I want this to always update automatically so when it comes next financial year in 01/04/2016 it will bring whatever is held from that date to whenever the report is being run.</p>
  
  <p>If anyone can please shed some light for me. thanks </p>
  
  <p>sql is:</p>
  
  <pre><code>SELECT
    PROPERTY.PRO_MANAGINGCOMPANY_DESCR,
    PROPERTY.PRO_SCHEME_DESCR,
    PROPERTY.PRO_SCHEME,
    SUM(REPAIR_CURRENT.REP_ESTIMATED_COST) as "Estimated Cost",
    nvl(SUM(REPAIR_CURRENT.REP_INVOICED_COST),SUM(REPAIR_CURRENT.REP_ESTIMATED_COST)) as "Estimated Cost Invoiced",
    SUM(REPAIR_CURRENT.REP_INVOICED_COST) as "Invoice Cost",
    to_char(REPAIR_CURRENT.REP_RAISED_DATE,'Mon') as "Month",
    to_number(to_char(to_date(REPAIR_CURRENT.REP_RAISED_DATE,'dd-mon-yy'),'mm')) as "Month No."
  FROM
   PROPERTY,
    REPAIR_CURRENT,
    SERVICE_REQUEST
  WHERE
    ( SERVICE_REQUEST.SRQ_PRO_REFNO=PROPERTY.PRO_REFNO  )
    AND  ( REPAIR_CURRENT.REP_SRQ_NO=SERVICE_REQUEST.SRQ_NO  )
    AND  
    (
    --PROPERTY.PRO_SCHEME  =   ( '00054'  )
     --AND
     REPAIR_CURRENT.REP_RAISED_DATE  BETWEEN  '01-APR-2015'  AND  sysdate
     AND
     REPAIR_CURRENT.REP_STATUS  &lt;&gt;  'CAN'
    )
  GROUP BY
    PROPERTY.PRO_MANAGINGCOMPANY_DESCR,
    PROPERTY.PRO_SCHEME_DESCR,
    PROPERTY.PRO_SCHEME,
    to_char(REPAIR_CURRENT.REP_RAISED_DATE,'Mon'),
    to_number(to_char(to_date(REPAIR_CURRENT.REP_RAISED_DATE,'dd-mon-yy'),'mm')) 
  </code></pre>