Hi,

I have a wierd problem in my vs 2005 report. I am connecting to a CSV file listing rows including a field with date time. It appears that this date/time field sometimes for some reason doesn't appear in the report.
I opened the CSV file itself to inspect the date time values and found out that sometimes this filed contains the split second value and sometimes it doesn't.

E.g (3/3/2009 11:39) and some other times it is like(29/03/2009 14:03:22)

I tried converting the field into string using the "STR" function in a formula, and even used SQL expression to force it to display as string but still it shows as blank. [IMG]smileys/smiley5.gif" align="middle" />

Please help..

Thx



Edited by leedo2k - 04 May 2009 at 4:25am