none
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.

    Thanks,

    Saturday, September 7, 2019 5:52 AM

Answers

  • 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

    image

    During runtime, this expression returns a string like this

    image


    Monday, September 9, 2019 4:46 AM
    Moderator

All replies