Thank you for your reply. It works perfectly.
If one were to use this in an expression however, could it be expressed as the following, I receive a syntax mistake when attempting to do this.
=if (Artikeltyp = 'z' and MovementDate > (dayend (Now (), -365)), ArticleNr;
It is brackets problem I have there.