Fiscal Year

[Jutheesh]

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.

[edwin]

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 
]

[sidhiq91]

@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')

[Jutheesh · Accepted solution]

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