Why isn't it working? Are you getting an error? Is your data wrong?

You will need to provide more details and a Tableau Packaged Workbook including some sample data.

Thanks

Hi Jin,

The only thing to add is a single quotation mark (') inside the date brackets.

This worked for us.

If [Date]>=DATE('7/1/2014')AND [Date]<=DATE('6/30/2015') THEN '2014-2015'

ELSEIF [Date]>=DATE('7/1/2015') AND [Date]<=DATE('6/30/2016') THEN '2015-2016'

END

Let us know.

Chris

HI Jun Wu,

Please find the attached screenshot. This field should be dynamic in nature. You have wrote dates in the calculated fields. If you use it you will have to update that calculated filed every Academic fin year. Below calc will solve your problem. Attaching tableau workbook 9.3 as well as excel data that I have used. You can use it along with day granurality as well.

FY Academic Year

if MONTH([Dates])>=7 and MONTH([Dates])<=12 THEN str(YEAR([Dates]))+"-"+STR(YEAR([Dates])+1)

elseif MONTH([Dates])>=1 and MONTH([Dates])<=6 THEN str(YEAR([Dates])-1)+"-"+STR(YEAR([Dates]))

END

Let me know if this helps.

Thanks and Regards,

Ashish Chaudhari