topic Re: Fiscal Year in App Development

Fiscal Year

Jutheesh — Fri, 15 Jul 2022 11:48:39 GMT

I need Extract Fiscal Year Based on.

Like if i have started my FY 23-04-2022 end date should be 22-04-203.

Please help in this concern asap.

Thanks & Regards,

Jutheesh.

Re: Fiscal Year

edwin — Fri, 15 Jul 2022 15:01:28 GMT

you may need to post sample input and expected output. however if you want to generate daily dates 1 year from a starting point you can use something like:

load date(STARTDATE+iterno()-1) as DATE
while date(STARTDATE+iterno()-1) <= addyears(STARTDATE,1);

load date(INPUTDATE) as STARTDATE inline [
INPUTDATE
23-04-2022
]

Re: Fiscal Year

sidhiq91 — Fri, 15 Jul 2022 15:09:26 GMT

@Jutheesh if you just want to find the FISCAL END YEAR below 2 solutions could help you:

Method1: =Date(AddYears([Fiscal start year],1),'DD-MM-YYYY')

Method2: =Date([Fiscal start year]+364,'DD-MM-YYYY')

Re: Fiscal Year

Jutheesh — Sat, 16 Jul 2022 05:01:10 GMT

@sidhiq91 i need this Fiscal year for multiple years like if i have date range from 2018-2023 data FY is starts from 25-04-2022 and ends with 24-04-22023.

Thanks & Regards,

Jutheesh.