I am trying to subtract a given date value from the current date and the following is what I am trying to use but its saying 'Type Mismatch'. I know this has got to be an easy one, Any suggestions??

txtDaysSinceAssnd = DateDiff("d", DateValue(Now), DateValue(txtDateEntered))