Partial Field Content Extract

He means do something like this:

<cfquery name="q">
select yourfield
from yourtable

Then
<cfoutput query="q">
#left(yourfield, 8)#
etc

ps, my syntax may be wrong

I've run into similar things. If you can't find any SQL functions that work with MS-Access, then just select the column as-is and do the conversions via CF using createDate(), createTime() and mid() to make the data look like what you want.

Dan

I don't really need two new fields. The first eight positions of the 20 position field is really yyyymmdd and needs to formatted in a report as yyyy/mm/dd. Positions 9-14 is really hhmmss and needs to formatted on report as hh:mm:ss.

I am using Access 2003 and I don't see any string function that does what I need. Again, I am using a clients database and the field that I am dealing with is not a date/time field. The DateFormat function will not work and returns an error stating that the data is not a valid date field.

Thanks
Ron

Different databases have different string functions. You didn't specify your database.

Some db's have a function called substr. Let's say your's does. Given that you can do,

select substr(yourfield, 1, 8) as abc, substr(yourfield, 9, 6) as xyz
from yourtable

are you absolutely sure you need the 2 new fields?