Problem with datetime type
Hi,
I imported a table from Paradox to SQL Server and I am using this table
for a report generation. That table in paradox contains a field "Entry"
which is of type Time.
When this table was imported the field type has changed to a field of
type datetime.
In the report I used a formula with Time({Table.Entry}) function for
just getting the time from that field. But it gives an error message
saying that " A date-time is required here.".
When I browsed the data in the field it shows 12/30/1899. That means
its only taking the date part.
Please help me.
Thanks
orange.
|