Is there code to work out the minimun/maximum scale on a chart from a date?

:confused: :confused: :confused: Can anyone help plz???

:wave: Plz:wave:

I have been trying to find a way round with the code i know but failed 6 or 7 times. (To enter it directly into the field but i can't manage it).