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

[machinist]

Can anyone help plz???

Plz

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).