Using date-to-datetime to convert a date to datetime so it can be incorporated in a calculation with the function now() which is a datetime

Result in report