Hello Drew,

timestamp column is used to records the time & date at whcih the record is added to the table, it has a default of getdate.

let me explain you again...

i am converting the date fileds and concatinating them. as i had converted to varchar i am getting error while i am trying to update the staus_id(bigint) column with this...

Thank you Gianluca, i really appreciate you.

Thank you Gianluca, you code fulfilled my requirement.

i need to knon one more thing, i replaced monthNumber <= 24 for getting two years data but it didn't work can you...