<?xml version="1.0" encoding="UTF-8"?><oembed><type>video</type><version>1.0</version><html>&lt;iframe src=&quot;https://www.loom.com/embed/2902e7077063426eb6c21c023f87b0c8&quot; frameborder=&quot;0&quot; width=&quot;1908&quot; height=&quot;1431&quot; webkitallowfullscreen mozallowfullscreen allowfullscreen&gt;&lt;/iframe&gt;</html><height>1431</height><width>1908</width><provider_name>Loom</provider_name><provider_url>https://www.loom.com</provider_url><thumbnail_height>1431</thumbnail_height><thumbnail_width>1908</thumbnail_width><thumbnail_url>https://cdn.loom.com/sessions/thumbnails/2902e7077063426eb6c21c023f87b0c8-86e48856c477180b.gif</thumbnail_url><duration>193.7</duration><title>Creating Point-in-Time Headcount Queries</title><description>Hi there, I am Adriana, and in this video I show you how to create a query on point in time headcount. You can use it to see how many employees you had on a specific day for turnover reports, payroll management, operational planning, recruiting, and more. I walk you through building a Leavers query by setting the start date to less than and the final date of employment to greater than, including an example for the 1st of May. I also show how to pull employees for all of 2023 by adjusting filters to 1 January 2024 and 31 December 2023. I ask you to use the digital assistant if you need help, and to watch your results after you click save.</description></oembed>