I am not sure if I am quite understanding the question. Would you be able to provide a sample workbook or a screenshot?
It sounds like those calculations Max(Date) and Min(Date) would work.
If the goal is to filter to those dates, the link below may be helpful.
I have a business requirement where I want to use the relative filter but the current date should be a user input and based on that I should be able to select Weekly, Monthly and Quarterly view. Or is there a way to create a date as an input for the user and based on that I will have a list from which I can select weekly, Monthly or a Quarterly view.