Hi.
I'm not sure where to put in the NZ function here. I'm trying to convert dates written as 20160917 to mm/dd/yyyy and use this function in a query: Formatted Date: CDate(Mid([Date Last Sold],5,2) & "/" & Right([Date Last Sold],2) & "/" & Left([Date Last Sold],4)).
The problem is that if there...