I am using CR 4.6 as supplied with VB5 Enterprise and looking at an Access
7.0 database.

In a table I have a date/time field from which I wish to extract the date,
the time and the year.

The only thing I can get is the date on it's own not even the whole
date/time field, even though I have switched off the Convert Date/Time to
date option and run verify database.

The Seagate site implied I could do one of two things in a formula either:-
{table.date}[12 to 22] which gives me an error " A string or array is
required here"
or
DTSTToTimeString({table.date}) which gives me an error "The remaining text
does not appear to be part of the formula"

Any ideas as this is surely a basic function (no pun intended) and I found
it hard to believe they have shipped a version which cannot handle date.time
fields.

Thanks for any ideas

I have the same problem with an oracle database. If you find any solutions
let me know!

Interesting little problem found the fix myself accidentally.

It appears that if you start a report with the option "Convert date/time to
date" set then even if you turn it off there is no apparent way to get it to
take effect.

If you start a new report again having turned it off no problem. It comes in
as a string so you then create formulas useing:-
{table.date}[1 to 10] to get the date
{table.date}[12 to 22]  to get the time

Good Luck