Is a date in this fiscal year or last fiscal year?

{note: preview=no}Assumes a fiscal year that starts on October 1st of any given year{endnote: trim=left}
Your payment of {formtext: name=price2} on {formdate: YYYY-MM-DD; end={time: YYYY-MM-DD}; name=payment_date2} was for {if: datetimediff(payment_date2, {time: YYYY-MM-DD; at={=currentyear}-10-01; pattern=YYYY-MM-DD}, "D")>0}the previous fiscal year{else}the current fiscal year.{endif}{note: preview=no}{currentyear={time: YYYY; shift=-1Y}}{endnote}

1 Like

Nice :+1: