Skip to content

Instantly share code, notes, and snippets.

@morganthrapp

morganthrapp/gist:94adb988bfd4a9fcfe29

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