I believe you need only to use the exists on the where clause.
load a // String
date(a,'FORMAT') as key
load b // Specific Date
b as key
You need to pay attention to the date format, the key field should be in equal format.