Spreadsheet: 814617d1674508378-filter-formula-not-pulling-correct-dates-report-builder-sample
Sheet: Step 4

 |  | 0 | Client: Unique Client ID | Client: Last Name | Client: First Name | Client: Middle Name | Client: Birthdate | Client: Mailing Address Line 1 | Client: Mailing City | Client: [NAME] | Client: Gender | Client: Ethnicity | Client: Referral Source | Program | Application Date | Start Date | End Date
 | 0 | 0 | [NAME] | 0 | 0 | 0 | 7/24/1995 | 0 | Union City | 94587 | Male | [P64]-Asian Indian | 0 | YSC Counseling | 7/12/2022 | 0 | 9/12/2022
#[NAME]! | 0 | 0 | FF-000209 | 0 | 0 | 0 | 6/6/2006 | 0 | Fremont | 94555 | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 9/1/2022 | 9/1/2022 | 9/1/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 1/3/2008 | 0 | Union City | 94587 | Male | [DPN]-Afghan/Middle E. | 0 | [NAME] | 7/11/2022 | 0 | 8/29/2022
#[NAME]! | 0 | 0 | AJ-000071 | 0 | 0 | 0 | 6/16/2006 | 0 | Fremont | 94536 | Male | [DPN]-Latino/Hispanic | 0 | [NAME] | 4/27/2022 | 4/27/2022 | 8/25/2022
#[NAME]! | 0 | 0 | AB-000031 | 0 | 0 | 0 | 9/29/2007 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | [NAME] | 4/12/2022 | 7/26/2022 | 7/26/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 7/24/1995 | 0 | Union City | 94587 | Male | [P64]-Asian Indian | 0 | YSC Case Mgmt | 6/14/2022 | 0 | 7/13/2022
#[NAME]! | 0 | 0 | SS-000013 | 0 | 0 | 0 | 8/25/2006 | 0 | Union City | 94587 | Female | [DPN]-African-American | 0 | YSC Counseling | 2/24/2021 | 0 | 7/12/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 8/14/2002 | 0 | [NAME] | 95377 | Male | [DPN]-African-American | 0 | LSC Life Skills Case Mgmt | 4/14/2022 | 0 | 6/14/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 8/14/2002 | 0 | [NAME] | 95377 | Male | [DPN]-African-American | 0 | YSC Counseling | 6/14/2022 | 0 | 6/14/2022
#[NAME]! | 0 | 0 | AG-000006 | 0 | 0 | 0 | 7/3/2008 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | YSC Counseling | 2/3/2021 | 2/3/2021 | 12/9/2022
#[NAME]! | 0 | 0 | CG-000127 | 0 | 0 | 0 | 5/3/2005 | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | LSC Diversion | 9/27/2022 | 9/27/2022 | 12/8/2022
#[NAME]! | 0 | 0 | RS-000123 | 0 | 0 | 0 | 4/24/2005 | 0 | Livermore | 94550 | Male | [P64]-Guamanian | 0 | LSC Diversion | 9/23/2022 | 9/26/2022 | 12/8/2022
#[NAME]! | 0 | 0 | GI-000028 | 0 | 0 | 0 | 11/25/2012 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | YSC Case Mgmt | 3/20/2022 | 0 | 12/7/2022
#[NAME]! | 0 | 0 | GI-000028 | 0 | 0 | 0 | 11/25/2012 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | YSC Case Mgmt | 9/23/2022 | 9/23/2022 | 12/7/2022
#[NAME]! | 0 | 0 | RA-000026 | 0 | 0 | 0 | 1/13/2014 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | YSC Case Mgmt | 3/16/2022 | 4/6/2022 | 12/7/2022
#[NAME]! | 0 | 0 | TE-000032 | 0 | 0 | 0 | 12/18/2005 | 0 | Oakland | 94608 | Male | [DPN]-African-American | 0 | LSC Life Skills Case Mgmt | 5/19/2022 | 0 | 12/7/2022
#[NAME]! | 0 | 0 | YZ-000018 | 0 | 0 | 0 | 5/7/2007 | 0 | Union City | 94587 | Female | [DPN]-Latino/Hispanic | 0 | LSC Life Skills Case Mgmt | 11/12/2021 | 11/22/2021 | 12/7/2022
#[NAME]! | 0 | 0 | AM-000126 | 0 | 0 | 0 | 5/15/2006 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 9/23/2022 | 9/26/2022 | 12/6/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 4/24/2005 | 0 | Union City | 94587 | Male | [P64]-Guamanian | 0 | LSC Diversion | 9/23/2022 | 9/26/2022 | 12/6/2022
#[NAME]! | 0 | 0 | DM-000034 | 0 | 0 | 0 | 7/15/2004 | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | YSC Case Mgmt | 5/23/2022 | 0 | 12/6/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 3/5/2005 | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | LSC Diversion | 9/23/2022 | 9/26/2022 | 12/6/2022
#[NAME]! | 0 | 0 | JD-000130 | 0 | 0 | 0 | 5/19/2005 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 9/23/2022 | 10/17/2022 | 12/6/2022
#[NAME]! | 0 | 0 | JE-000140 | 0 | 0 | 0 | 2/18/2005 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 9/30/2022 | [NAME] | 12/6/2022
#[NAME]! | 0 | 0 | JA-000121 | 0 | 0 | 0 | 11/10/2006 | 0 | Union City | 94587 | Male | Other | 0 | LSC Diversion | 9/23/2022 | 9/26/2022 | 12/6/2022
#[NAME]! | 0 | 0 | LL-000156 | 0 | 0 | 0 | 12/27/2004 | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | LSC Diversion | 9/27/2022 | 10/10/2022 | 12/6/2022
#[NAME]! | 0 | 0 | DE-000155 | 0 | 0 | 0 | 1/19/2011 | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | LSC Life Skills Case Mgmt | 10/6/2022 | 11/1/2022 | [NAME]
#[NAME]! | 0 | 0 | DE-000155 | 0 | 0 | 0 | 1/19/2011 | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | YSC Case Mgmt | 10/6/2022 | 11/1/2022 | [NAME]
#[NAME]! | 0 | 0 | SC-000157 | 0 | 0 | 0 | 2/15/2005 | 0 | Hayward | 94544 | Male | [P64]-American Indian/Alaska Native | 0 | YSC Case Mgmt | 10/17/2022 | 10/20/2022 | 12/2/2022
#[NAME]! | 0 | 0 | SK-000125 | 0 | 0 | 0 | 8/17/2004 | 0 | Union City | 94587 | Male | [P64]-Middle Eastern/North African | 0 | LSC Diversion | 9/23/2022 | 9/26/2022 | 12/14/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 12/17/2007 | 0 | Union City | 94587 |  |  | 0 | P64  Courses | 9/7/2022 | 11/9/2022 | 11/9/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 12/17/2007 | 0 | Union City | 94587 |  |  | 0 | P64  Courses | 10/19/2022 | 11/9/2022 | 11/9/2022
#[NAME]! | 0 | 0 | SH-000154 | 0 | 0 | 0 | 11/6/2007 | 0 | Union City | 94587 | Female | [DPN]-Latino/Hispanic | 0 | P64  Courses | 10/6/2022 | 11/3/2022 | 11/9/2022
#[NAME]! | 0 | 0 | MY-000152 | 0 | 0 | 0 | 11/5/2008 | 0 | Union City | 94587 | Male | [DPN]-Afghan/Middle E. | 0 | YSC Case Mgmt | 9/30/2022 | 10/5/2022 | 11/4/2022
#[NAME]! | 0 | 0 | MY-000152 | 0 | 0 | 0 | 11/5/2008 | 0 | Union City | 94587 | Male | [DPN]-Afghan/Middle E. | 0 | [NAME] | 9/30/2022 | 10/5/2022 | 11/4/2022
#[NAME]! | 0 | 0 | AM-000164 | 0 | 0 | 0 | 1/9/2009 | 0 | Union City | 94587 | Female | [DPN]-Latino/Hispanic | 0 | YSC Counseling | 10/18/2022 | 10/20/2022 | 11/30/2022
#[NAME]! | 0 | 0 | NN-000163 | 0 | 0 | 0 | 8/19/2008 | 0 | Union City | 94587 |  |  | 0 | YSC Counseling | 10/18/2022 | 10/20/2022 | 11/30/2022
#[NAME]! | 0 | 0 | SS-000072 | 0 | 0 | 0 | 3/3/2007 | 0 | Union City | 94587 | Male | [DPN]-Am indian/[NAME]. | 0 | [NAME] | 5/17/2022 | 7/12/2022 | 11/29/2022
#[NAME]! | 0 | 0 | AL-000078 | 0 | 0 | 0 | 4/2/2006 | 0 | Union City | 94587 |  |  | 0 | YSC Case Mgmt | [NAME] | 0 | 11/28/2022
#[NAME]! | 0 | 0 | DC-000171 | 0 | 0 | 0 | 6/23/2008 | 0 | Union City | 94587 | Male | [P64]-Filipino | 0 | YSC Counseling | 10/20/2022 | 11/1/2022 | 11/28/2022
#[NAME]! | 0 | 0 | DC-000171 | 0 | 0 | 0 | 6/23/2008 | 0 | Union City | 94587 | Male | [P64]-Filipino | 0 | YSC Case Mgmt | 10/20/2022 | 0 | 11/28/2022
#[NAME]! | 0 | 0 | SF-000216 | 0 | 0 | 0 | 0 | 0 | Fremont | 94555 | Female | [DPN]-Asian/Pacific Is. | 0 | INTAKE | 9/9/2022 | 11/17/2022 | 11/28/2022
#[NAME]! | 0 | 0 | KS-000094 | 0 | 0 | 0 | 9/6/2007 | 0 | Union City | 94587 |  |  | 0 | LSC Life Skills Case Mgmt | 9/7/2022 | 10/18/2022 | 11/21/2022
#[NAME]! | 0 | 0 | KS-000094 | 0 | 0 | 0 | 9/6/2007 | 0 | Union City | 94587 |  |  | 0 | P64  Courses | 9/7/2022 | 0 | 11/21/2022
#[NAME]! | 0 | 0 | KS-000094 | 0 | 0 | 0 | 9/6/2007 | 0 | Union City | 94587 |  |  | 0 | P64  Courses | 9/7/2022 | 10/18/2022 | 11/21/2022
#[NAME]! | 0 | 0 | KS-000094 | 0 | 0 | 0 | 9/6/2007 | 0 | Union City | 94587 |  |  | 0 | P64  Courses | 9/7/2022 | 10/18/2022 | 11/21/2022
#[NAME]! | 0 | 0 | SF-000093 | 0 | 0 | 0 | 5/7/2008 | 0 | Union City | 94587 | Female |  | 0 | P64  Courses | 9/7/2022 | 10/18/2022 | 11/21/2022
#[NAME]! | 0 | 0 | SF-000093 | 0 | 0 | 0 | 5/7/2008 | 0 | Union City | 94587 | Female |  | 0 | P64  Courses | 9/7/2022 | 10/18/2022 | 11/21/2022
#[NAME]! | 0 | 0 | SF-000093 | 0 | 0 | 0 | 5/7/2008 | 0 | Union City | 94587 | Female |  | 0 | P64  Courses | 9/7/2022 | 10/18/2022 | 11/21/2022
#[NAME]! | 0 | 0 | DS-000200 | 0 | 0 | 0 | 8/16/2008 | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | INTAKE | 11/11/2022 | 11/17/2022 | 11/17/2022
#[NAME]! | 0 | 0 | ds-000198 | 0 | 0 | 0 | 1/29/2012 | 0 | union city | 94587 | Female | [DPN]-African-American | 0 | INTAKE | 11/11/2022 | 11/17/2022 | 11/17/2022
#[NAME]! | 0 | 0 | FF-000208 | 0 | 0 | 0 | 7/19/2007 | 0 | Fremont | 94539 | Female | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 10/6/2022 | 10/13/2022 | 11/17/2022
#[NAME]! | 0 | 0 | hs-000197 | 0 | 0 | 0 | 1/28/2010 | 0 | union city | 94587 | Female | [DPN]-African-American | 0 | INTAKE | 11/11/2022 | 11/17/2022 | 11/17/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 5/23/2007 | 0 | union city | 94587 | Male | [DPN]-African-American | 0 | INTAKE | 11/11/2022 | 11/17/2022 | 11/17/2022
#[NAME]! | 0 | 0 | mg-000199 | 0 | 0 | 0 | 4/22/2014 | 0 | union city | 94587 | Female | [DPN]-African-American | 0 | INTAKE | 11/11/2022 | 11/17/2022 | 11/17/2022
#[NAME]! | 0 | 0 | MQ-000077 | 0 | 0 | 0 | 10/23/2007 | 0 | Union City | 94587 |  |  | 0 | YSC Counseling | 7/18/2022 | 7/19/2022 | 11/17/2022
#[NAME]! | 0 | 0 | ns-000196 | 0 | 0 | 0 | 9/9/2009 | 0 | union city | 94587 | Female | [DPN]-African-American | 0 | INTAKE | 11/11/2022 | 0 | 11/17/2022
#[NAME]! | 0 | 0 | TG-000194 | 0 | 0 | 0 | 1/4/2005 | 0 | union city | 9458 | Male | [DPN]-African-American | 0 | INTAKE | 11/11/2022 | 11/17/2022 | 11/17/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 3/27/2007 | 0 | Union City | 94587 | Male | [DPN]-Afghan/Middle E. | 0 | LSC Restorative Justice CM | 11/17/2021 | 0 | 11/17/2021
#[NAME]! | 0 | 0 | CE-000062 | 0 | 0 | 0 | 7/25/2007 | 0 | Union City | 94587 | Non-binary/3rd Gender | [DPN]-Am indian/[NAME]. | 0 | INTAKE | 11/9/2022 | 11/13/2022 | 11/16/2022
#[NAME]! | 0 | 0 | CE-000062 | 0 | 0 | 0 | 7/25/2007 | 0 | Union City | 94587 | Non-binary/3rd Gender | [DPN]-Am indian/[NAME]. | 0 | YSC Counseling | 11/1/2022 | 11/2/2022 | 11/15/2022
#[NAME]! | 0 | 0 | DB-000165 | 0 | 0 | 0 | 8/27/2009 | 0 | Union City | 94544 | Male | [DPN]-African-American | 0 | YSC Counseling | 10/19/2022 | 10/20/2022 | 11/15/2022
#[NAME]! | 0 | 0 | JG-000021 | 0 | 0 | 0 | 1/7/2007 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | [NAME] | 4/25/2022 | 0 | 11/15/2022
#[NAME]! | 0 | 0 | NH-000069 | 0 | 0 | 0 | 3/13/2004 | 0 | Union City | 94587 |  | [DPN]-African-American | 0 | YSC Counseling | 2/4/2021 | 7/27/2021 | 11/15/2022
#[NAME]! | 0 | 0 | DB-000109 | 0 | 0 | 0 | 8/2/2012 | 0 |  |  | Male | [DPN]-Am indian/[NAME]. | 0 | LSC Diversion | 9/21/2022 | 0 | 10/5/2022
#[NAME]! | 0 | 0 | ER-000111 | 0 | 0 | 0 | 1/6/2014 | 0 |  |  | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 9/21/2022 | 0 | 10/5/2022
#[NAME]! | 0 | 0 | RB-000110 | 0 | 0 | 0 | 7/5/2013 | 0 |  |  | Male | [DPN]-Am indian/[NAME]. | 0 | LSC Diversion | 9/21/2022 | 0 | 10/5/2022
#[NAME]! | 0 | 0 | LW-000108 | 0 | 0 | 0 | [NAME] | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | LSC Diversion | 9/20/2022 | 9/20/2022 | 10/27/2022
#[NAME]! | 0 | 0 | JP-000107 | 0 | 0 | 0 | 9/9/2011 | 0 |  |  | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 9/19/2022 | 9/23/2022 | 10/26/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 9/6/2011 | 0 | Union City | 94587 | Male | [DPN]-Other/Unknown | 0 | LSC Diversion | 9/20/2022 | 9/27/2022 | 10/26/2022
#[NAME]! | 0 | 0 | LV-000102 | 0 | 0 | 0 | 1/1/2013 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 9/20/2022 | 9/23/2022 | 10/26/2022
#[NAME]! | 0 | 0 | EG-000139 | 0 | 0 | 0 | 7/1/2005 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 9/30/2022 | 9/30/2022 | 10/25/2022
#[NAME]! | 0 | 0 | FF-000202 | 0 | 0 | 0 | 1/17/2007 | 0 | Fremont | 94538 | Female | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 10/24/2022 | 10/25/2022 | 10/25/2022
#[NAME]! | 0 | 0 | FF-000211 | 0 | 0 | 0 | 1/1/1901 | 0 | Fremont | 94538 | Female | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 10/25/2022 | 10/25/2022 | 10/25/2022
#[NAME]! | 0 | 0 | FF-000203 | 0 | 0 | 0 | 4/26/2007 | 0 | Fremont | 94538 | Female | [DPN]-Other/Unknown | 0 | LSC Diversion | 10/25/2022 | 10/25/2022 | 10/25/2022
#[NAME]! | 0 | 0 | FF-000204 | 0 | 0 | 0 | 6/11/2007 | 0 | Fremont | 94538 | Female | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 10/25/2022 | 10/25/2022 | 10/25/2022
#[NAME]! | 0 | 0 | FF-000206 | 0 | 0 | 0 | 7/19/2007 | 0 | Fremont | 94539 | Female | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 10/24/2022 | 10/25/2022 | 10/25/2022
#[NAME]! | 0 | 0 | FF-000207 | 0 | 0 | 0 | 9/16/2007 | 0 | Fremont | 94538 | Female | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 10/24/2022 | 10/25/2022 | 10/25/2022
#[NAME]! | 0 | 0 | FF-000210 | 0 | 0 | 0 | 9/9/2006 | 0 | Fremont | 94538 | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 10/24/2022 | 10/25/2022 | 10/25/2022
#[NAME]! | 0 | 0 | [NAME] | 0 | 0 | 0 | 9/19/2003 | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | LSC Diversion | 9/30/2022 | 10/18/2022 | 10/25/2022
#[NAME]! | 0 | 0 | MW-000137 | 0 | 0 | 0 | 8/7/2004 | 0 | UC | 94587 | Male | [DPN]-African-American | 0 | LSC Diversion | 9/30/2022 | 9/30/2022 | 10/25/2022
#[NAME]! | 0 | 0 | AT-000023 | 0 | 0 | 0 | 7/17/2005 | 0 | Union City | 94587 | Male | [DPN]-Afghan/Middle E. | 0 | LSC Restorative Justice CM | 10/21/2022 | 0 | 10/21/2022
#[NAME]! | 0 | 0 | CE-000062 | 0 | 0 | 0 | 7/25/2007 | 0 | Union City | 94587 | Non-binary/3rd Gender | [DPN]-Am indian/[NAME]. | 0 | LSC Diversion | 9/26/2022 | 0 | 10/21/2022
#[NAME]! | 0 | 0 | DR-000135 | 0 | 0 | 0 | 1/21/2007 | 0 | Union City | 94587 | Male | [DPN]-Mixed Ethnicity | 0 | P64  Courses | 9/30/2022 | 9/30/2022 | 10/21/2022
#[NAME]! | 0 | 0 | GD-000136 | 0 | 0 | 0 | 2/5/1966 | 0 | Union City | 94587 | Female | [P64]-Unknown | 0 | YSC Counseling | 9/27/2022 | 9/28/2022 | 10/20/2022
#[NAME]! | 0 | 0 | IG-000104 | 0 | 0 | 0 | 11/29/2012 | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | LSC Diversion | 9/20/2022 | 10/4/2022 | 10/20/2022
#[NAME]! | 0 | 0 | AF-000103 | 0 | 0 | 0 | 11/29/2012 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 9/20/2022 | 10/5/2022 | 10/18/2022
#[NAME]! | 0 | 0 | DM-000112 | 0 | 0 | 0 | [NAME] | 0 | Union City | 94587 | Male | [DPN]-African-American | 0 | LSC Diversion | 9/21/2022 | 9/27/2022 | 10/18/2022
#[NAME]! | 0 | 0 | FF-000205 | 0 | 0 | 0 | 6/28/2007 | 0 | Fremont | 94539 | Male | [DPN]-Latino/Hispanic | 0 | LSC Diversion | 10/6/2022 | 10/13/2022 | 10/13/2022
#[NAME]! | 0 | 0 | ER-000073 | 0 | 0 | 0 | 4/18/2005 | 0 | Union City | 94587 | Male | [DPN]-Latino/Hispanic | 0 | YSC Case Mgmt | 6/17/2022 | 0 | 10/10/2022
#[NAME]! | 0 | 0 | AF-000174 | 0 | 0 | 0 | 10/15/2007 | 0 | Union City | 94587 | Male | [DPN]-Am indian/[NAME]. | 0 | YSC Case Mgmt | 10/28/2022 | 11/14/2022 | 1/17/2023
#[NAME]! | 0 | 0 | CP-000222 | 0 | 0 | 0 | 9/13/2005 | 0 | Union City | 94587 | Female | [DPN]-Asian/Pacific Is. | 0 | INTAKE | 12/2/2022 | 12/8/2022 | 1/12/2023