• Hi lowell

    I've managed to sort it now, figured it out about 2 mins after posting. Having a blond day today.

    In the THEN clause I just -7 after the calculation. This moves all predicted dates back 7 days.

    Sorry for not updating post, only just had a spare minute.

    Thanks for the help, it's appreciated 🙂