---
title: SQL - New Clients by Date
description: VetLinkPro SQL - New Clients by Date
---

# VetLink PRO

 Connecting Veterinary Professionals with Smarter Solutions

[Skip to content](https://help.vetlinkpro.com/vetlinkpro/sql-new-clients-by-date#main-content)

English - Australia

Show submenu for translations

![Vetlinkpro - Intergrity - excellence - clarity](https://help.vetlinkpro.com/hs-fs/hubfs/MAIN_2026-1.png?width=528&height=160&name=MAIN_2026-1.png)

Open main navigation

Close main navigation

- English - Australia
  
  Show submenu for translations
- Contact us

 Contact us

 How can we help you?

- There are no suggestions because the search field is empty.

1. [VetLink PRO](https://help.vetlinkpro.com/vetlinkpro)
2. [Support](https://help.vetlinkpro.com/vetlinkpro/support)
3. [Exports](https://help.vetlinkpro.com/vetlinkpro/support#exports)

# SQL - New Clients by Date

## v7,v6

See [Create Export to CSV using SQL Query](https://help.vetlinkpro.com/vetlinkpro/create-export-to-csv-using-sql-query) for information on using query below for export to csv.

 

select dateadd(-extract(weekday from BM."Dis\_Date") day to BM."Dis\_Date") as "Week Starting",

count(distinct BM."Ref\_Number") as "New Clients"

from   "General\_Ledger\_Log" GL

left outer join "Bill\_Main" BM on GL."Trn\_Ref"=BM."Ref\_Number"

where  GL."Trn\_Source"='D' and

                GL."Trn\_Type"='B' and

                GL."Trn\_Ref\_Type"='I' and

                GL."Prd\_Class" in ('S', 'F', 'R', 'M', 'D', '$', 'B') and

                GL."Trn\_Date" \>= :DateLo/\*Start Date\*/ and

                GL."Trn\_Date" \<= :DateHi/\*Finish Date\*/ and

                (0 = :BranchALL/\*Branch\*/ or GL."Trn\_Branch" = :BranchALL/\*Branch\*/) and

                coalesce(GL."Dont\_Report", null, '') \<\> 'Y' and

                BM."New\_Client" = 'Y'

group by 1

- [Support](https://help.vetlinkpro.com/vetlinkpro/support#main-content)

    - [Client Portal](https://help.vetlinkpro.com/vetlinkpro/support#client-portal)
    - [Creditors](https://help.vetlinkpro.com/vetlinkpro/support#creditors)
    - [Upgrade](https://help.vetlinkpro.com/vetlinkpro/support#upgrade)
    - [Payments](https://help.vetlinkpro.com/vetlinkpro/support#payments)
    - [Patient](https://help.vetlinkpro.com/vetlinkpro/support#patient)
    - [Product](https://help.vetlinkpro.com/vetlinkpro/support#product)
    - [Xero](https://help.vetlinkpro.com/vetlinkpro/support#xero)
    - [Clinical History](https://help.vetlinkpro.com/vetlinkpro/support#clinical-history)
    - [RDS Setup](https://help.vetlinkpro.com/vetlinkpro/support#rds-setup)
    - [Client](https://help.vetlinkpro.com/vetlinkpro/support#client)
    - [Diary](https://help.vetlinkpro.com/vetlinkpro/support#diary)
    - [Mailers](https://help.vetlinkpro.com/vetlinkpro/support#mailers)
    - [Exports](https://help.vetlinkpro.com/vetlinkpro/support#exports)
    - [Stocktake](https://help.vetlinkpro.com/vetlinkpro/support#stocktake)
    - [Reports](https://help.vetlinkpro.com/vetlinkpro/support#reports)
    - [EOP / Statements](https://help.vetlinkpro.com/vetlinkpro/support#eop-statements)
    - [Eforms / Digital Forms](https://help.vetlinkpro.com/vetlinkpro/support#eforms-digital-forms)
    - [Other](https://help.vetlinkpro.com/vetlinkpro/support#other)
    - [Printing](https://help.vetlinkpro.com/vetlinkpro/support#printing)
    - [Email](https://help.vetlinkpro.com/vetlinkpro/support#email)
    - [Server / Technical](https://help.vetlinkpro.com/vetlinkpro/support#server-technical)
    - [Insurance](https://help.vetlinkpro.com/vetlinkpro/support#insurance)
    - [Bill](https://help.vetlinkpro.com/vetlinkpro/support#bill)
    - [Vac Reminders](https://help.vetlinkpro.com/vetlinkpro/support#vac-reminders)
    - [Online Booking](https://help.vetlinkpro.com/vetlinkpro/support#online-booking)
    - [Mobile Billing](https://help.vetlinkpro.com/vetlinkpro/support#mobile-billing)
    - [Barcoding](https://help.vetlinkpro.com/vetlinkpro/support#barcoding)
    - [SMS](https://help.vetlinkpro.com/vetlinkpro/support#sms)
    - [General Ledger](https://help.vetlinkpro.com/vetlinkpro/support#general-ledger)
    - [Staff](https://help.vetlinkpro.com/vetlinkpro/support#staff)
    - [Telemedicine](https://help.vetlinkpro.com/vetlinkpro/support#telemedicine)
- [Manual](https://help.vetlinkpro.com/vetlinkpro/manual#main-content)

    - [6.1](https://help.vetlinkpro.com/vetlinkpro/manual#6-1)
    - [7.0](https://help.vetlinkpro.com/vetlinkpro/manual#7-0)

[![Vetlinkpro - Intergrity - excellence - clarity](https://help.vetlinkpro.com/hs-fs/hubfs/MAIN_2026-1.png?width=528&height=160&name=MAIN_2026-1.png "Vetlinkpro - Intergrity - excellence - clarity")](https://www.vetlinkpro.com)

<https://www.facebook.com/> <https://www.twitter.com/> <https://www.instagram.com/> <https://podcasts.apple.com/> [mailto:email@email.com](mailto:email@email.com)

Copyright © 2026, VetlinkPRO