Trying to pull data from Salesforce: Login History Object
I want to pull the earliest login time for each day, per UserID. The attachement includes the actual data and you can see there are multiple datetime entries per UserID. I have limited this to three unique USERID and two weeks of login.
Any help or guidance would be greatly appreciated.
UserID and Login Data
| UserId | LoginTime |
| 0050B000006kzcIQAQ | 3/2/2025 23:03 |
| 0050B000006kzcIQAQ | 3/3/2025 14:52 |
| 0050B000006kzcIQAQ | 3/3/2025 15:06 |
| 0050B000006kzcIQAQ | 3/3/2025 15:06 |
| 0050B000006kzcIQAQ | 3/3/2025 15:08 |
| 0050B000006kzcIQAQ | 3/4/2025 1:40 |
| 0050B000006kzcIQAQ | 3/4/2025 14:36 |
| 0050B000006kzcIQAQ | 3/4/2025 14:37 |
| 0050B000006kzcIQAQ | 3/4/2025 14:37 |
| 0050B000006kzcIQAQ | 3/4/2025 14:37 |
| 0050B000006kzcIQAQ | 3/4/2025 14:37 |
| 0050B000006kzcIQAQ | 3/4/2025 18:46 |
| 0050B000006kzcIQAQ | 3/4/2025 18:46 |
| 0050B000006kzcIQAQ | 3/6/2025 16:14 |
| 0050B000006kzcIQAQ | 3/6/2025 16:15 |
| 0050B000006naKlQAI | 3/3/2025 19:05 |
| 0050B000006naKlQAI | 3/3/2025 19:36 |
| 0050B000006naKlQAI | 3/3/2025 19:36 |
| 0050B000006naKlQAI | 3/3/2025 21:59 |
| 0050B000006naKlQAI | 3/3/2025 22:05 |
| 0050B000006naKlQAI | 3/3/2025 22:17 |
| 0050B000006naKlQAI | 3/3/2025 22:34 |
| 0050B000006naKlQAI | 3/4/2025 0:11 |
| 0050B000006naKlQAI | 3/4/2025 0:32 |
| 0050B000006naKlQAI | 3/4/2025 2:54 |
| 0050B000006naKlQAI | 3/4/2025 14:00 |
| 0050B000006naKlQAI | 3/4/2025 14:13 |
