Forum Discussion
Calculate
1 Reply
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) )
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) )