How to bring India financial years base on month using SQL select query RRS feed

  • Question

  • User-471420332 posted

    I need financial year like below format, in India financial year runs from 1 April to 31 March in every year.

    1. Example 1 <gwmw class="ginger-module-highlighter-mistake-type-1" id="gwmw-15808821173586221311272">april</gwmw> 2018 to 31 march 2019 (2018-2019)
    2. Example 1 <gwmw class="ginger-module-highlighter-mistake-type-1" id="gwmw-15808821173603055643187">april</gwmw> 2019 to 31 march 2020 (2019-2020)

    I want below output and select query <gwmw class="ginger-module-highlighter-mistake-type-3" id="gwmw-15808821173622452077317">need</gwmw> below columns from 2018 to <gwmw class="ginger-module-highlighter-mistake-type-3" id="gwmw-15808821173626693713273">currently</gwmw> date, if the new April month starts then again new dropdown value should come, example 2020 year past then if current month April 2021 then the new dropdown value 2021-2022 should come like that <gwmw class="ginger-module-highlighter-mistake-type-1" id="gwmw-15808821173627913224186">so on</gwmw>.

    Year       <gwmw class="ginger-module-highlighter-mistake-type-1" id="gwmw-15808821177721981095960">FinancialYear</gwmw>
    2018       2018-2019 
    2019       2019-2020
    Wednesday, February 5, 2020 5:55 AM

All replies

  • User475983607 posted

    In my experience, this problem is solved by adding a record to a table.

    Are you having difficulty writing a record to a database, reading a record, populating a select, finding the current day, month, year? Share your code and explain what problem you are having. 

    Wednesday, February 5, 2020 12:17 PM