Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

How can i assign Fiscal year to dates between 1 nov 2018 to 31 oct 2019 as Fiscal 19

1 REPLY 1

DateTimeDiff function would come in handy.

Formula

FiscalYear = DateTimeDiff([Date],"1999-11-01","years")

Workflow

Output

Assigning Fiscal to date ranges