• What happens if you wrap the expression in the CDate function? Like:

    =CDate(Format(DateAdd("d", -1, now()),"dd/MM/yyyy"))