The Mendix documentation is not complete in what patterns are possible for FormatDateTime conversions Anyone who wants to know the number of a day in a week should use formatDateTime([dateAttribute], 'u') ------- (Since java 7) Just for those who didn't know yet.