Template:Historical sales ytd criteria

From MediaWiki

Jump to: navigation, search


This template contains an SQL "WHERE" clause that will select data for the disjoint time period beginning with each year since 2006, up to the date in that year corresponding to the last recorded date in the current year.

This allows one to understand how sales are doing for each year, up to the current date.

It is only used in historical sales YTD, so far.

This was done so that, for each new year, you only need to add one OR clause in one place.


  1. (optional) a qualifying table alias, with trailing dot, for when `Date` is ambiguous.


Trying to put a table qualifying parameter in, but "{{{1}}}" is showing up literally in the query!


  • {{historical sales ytd criteria}}

See Also


Share your opinion

blog comments powered by Disqus
Personal tools
Get our newsletter!
Email Address:

entry points
help (off site)
Environmental jobs, green volunteering, good work! Powered by the wind! This server and other
EcoReality operations
are 100% wind powered.
Powered by Mac OS X Powered by Mac MediaWiki Powered by MariaDB Powered by Valentina Studio Pro