internal static string GetBranchesQuery(DateFilter dateFilter)
        {
            if (dateFilter.FilterType == DateFilter.Type.AllTime)
            {
                return(QueryConstants.BranchesBeginningQuery);
            }

            string whereClause = QueryConstants.GetDateWhereClause(
                dateFilter.GetFilterDate(DateTime.UtcNow));

            return(string.Format("{0} {1}",
                                 QueryConstants.BranchesBeginningQuery,
                                 whereClause));
        }