1 Reply Latest reply: Jul 26, 2013 6:18 PM by rp0428 RSS

    converting dates to fiscal year

    user13168644

      Hi,

      I have a table that has a column storing dates along with other information, I want to write a query to convert the dates into fiscal year. ( June last year to July next year).

      [code]

      Ex: 2011(jul2011-jun-2012)

            2012(jul-2012- jun-2013)

      [/code]

       

      Thanks