You are right, Lutz. I stated that the fieldname - functionDate is of dateTime datatype.

That is correct.

The other statements, as you correctly pointed out created contradictions and confusion.

Sorry about that.

Thanks Welsh.

Thanks a lot Lutz

On the db, we have functionDate which records only date portion as in 3/4/2010.

Then there is the time portion which records only time as in 2:15:13PM(AM).

I just...

Thank you very much for your response.

I thought I did just that.

I attemped to show *how* the excel file looks like.

I would like the db to have similar layout.

The users...