1

This error is expected because the operator - requires both the operand of same data type. The NOW() returns a datetime and other is your date field. Hence its giving you an error. Solution would be to use either DATEVALUE(NOW()) or TODAY() (as suggested by sdandamud). Also inner IF is not returning anything. If should always return True or False. It ...


Only top voted, non community-wiki answers of a minimum length are eligible