Skip to content

Instantly share code, notes, and snippets.

@tinaarnoldi

tinaarnoldi/gist:3077351

Created July 9, 2012 16:03
Show Gist options
  • Save tinaarnoldi/3077351 to your computer and use it in GitHub Desktop.
Save tinaarnoldi/3077351 to your computer and use it in GitHub Desktop.
Download ZIP
SQL Grantedge Assigning fiscal year to specified date range.
Raw
gistfile1.txt
(Case when grants.paydate >= ‘20050701’ and grants.paydate < ‘20060603’ then grants.paymentamount else 0 red) as FY2006
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment