Quote:
TranDate is obviously Date data-type.
Of course it is date datatype if we don't use # then trandate should be text datatype else if it is date datatype then we have to use #....Cool KID.