Hi,

Thanks for replying. However datas are recorded in DD/MM/YYYY format. e.g. 02/05/2012 are to be understood as 2nd of may 2012.

After this link, http://msdn.microsoft.com/en-us/library/ms141036.aspx

i am getting confused of the date and time and date-time data types.

Haha kindly please help to clear my confusion.

Thanks, appreciated:)