[sriram225]

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.