Try doing the following:
1) Right click your continuous date and check the option for 'show missing values'
2) Create a calculated field
The calculated field forces a table calculation to check for the value do to the lookup. If the value in every cell does not exist then it will be null. Finally the ZN portion of the function assigns each of these Nulls to be 0.
Thank you very much!