Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Calculate

Need Help
Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
3 years ago

Anonymous Try:

FY_Start Date =
IF( MONTH([Date]) < 10, DATE(YEAR([Date])-1,10,1), DATE(YEAR([Date]),10,1) )

FY_END_Date = IF( MONTH([Date]) < 10, DATE(YEAR([Date]),9,30), DATE(YEAR([Date])+1,9,30) )