获取在不同服务中的sql中记录的活动状态的日期

I am trying to find out date from which that particular client is active regardless of different service provided by that client. I am able to get the latest state but that doesn't help me with what I am looking for!!I am trying to find out date from which that pa