Re: DatePart in cfquery

["nellic7"]

Thank you so much paross1 for your help.  The code works well I did run into a 
small issue then I went online and found out that I could use FM with the 
TO_CHAR function to omit the leading zeros.  Thanks so much again you saved me 
allot of time and fustration!
 :smile;