Hi,
It is not possible to use normpdf with the input in datetime format (which is not in scalar format). This command requires scalar values/ array of scalar values as input. You are getting result with the 1st command because datenum converts the date into number and it is equal to the number of days from January 0, 0000.
For more information on normpdf, you can refer the below link: