Thanks for the tips but neither helped
Field is behaving like a date field in crystal - have converted to date time using
CDateTime ({Parking_Facts.Offence_Time})
However data shows as
1/01/1900 12:00:00AM
In Access data shows as Date/Time field Displayed as 11:11:00 AM...
I have a small issue with date conversion... One of the fields in my database(SQL 2000) holds a date and time (i.e 1900-01-01 11:55:00)
When I look at the field via crystal it sees the field as a Date field, When I look at the field via Access 2000 it correctly displays the time.
I have tried...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.