I notice the post is more than one year old. I know by this time, you would have resolved this simple aspect. Still I am replying as the status remains 'Not Answered'.
Service Date is already loaded in your document as date only in mm/dd/yyyy format.
So Date# is not required here as it is used to convert string to date. Date(Service Date, 'DD-MMM-YYYY') gives formatted date.