Logic apps fiscal year RRS feed

  • Question

  • Hi,

    Our fiscal year starts from April 1st and ends on March 31st next year. So current fiscal year is 2019-2020. Is is possible to find this using date function? I would preferably want the fiscal year to look like 19-20.


    Saturday, September 7, 2019 5:52 AM


  • Don't think there is a built-in function for that, but you should be able to write an expression for it. Something like this should do I suppose

    if(greaterOrEquals(int(utcNow('MM')), 4), concat(utcNow('yy'), '-', add(int(utcNow('yy')), 1)), concat(sub(int(utcNow('yy')), 1), '-', utcNow('yy')))

    You can simply assign this to a variable for later use


    During runtime, this expression returns a string like this


    Monday, September 9, 2019 4:46 AM

All replies