Skip to content

Instantly share code, notes, and snippets.

@morganthrapp

morganthrapp/gist:13a53e2c5fa98872e045

Last active August 29, 2015 14:14
Show Gist options
  • Save morganthrapp/13a53e2c5fa98872e045 to your computer and use it in GitHub Desktop.
Save morganthrapp/13a53e2c5fa98872e045 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
CASE
WHEN DATEDIFF(d, LienStartDate, GETDATE()) - (DATEDIFF(yyyy, LienStartDate, GETDATE()) * 365) >= 0
THEN Amount * (DATEDIFF(m, LienSTartDate, GETDATE()) * 0.01)
WHEN DATEDIFF(d, LienStartDate, GETDATE()) - (DATEDIFF(yyyy, LienStartDate, GETDATE()) * 365) < 0
THEN Amount * ((DATEDIFF(m, LienStartDate, GETDATE()) - 1) * 0.01) END
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment