Skip to content

Instantly share code, notes, and snippets.

@gtallen1187

gtallen1187/auto-date (qq)

Created November 20, 2013 23:04
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
  • Save gtallen1187/7572814 to your computer and use it in GitHub Desktop.
Save gtallen1187/7572814 to your computer and use it in GitHub Desktop.
Download ZIP
date automatically fast-forwards to the end of the current quarter
Raw
auto-date (qq)
where datediff(day,enc.encounterdate,(dateadd(qq,datediff(qq,0,getdate())+1,0))) between 0 and 365
@gtallen1187
Copy link
Author

courtesy of the main man matt plunkett

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment