Try to change recived format to another display format

[davefm1]

Hi,

my data is coming back in a procedure and is the following format however the o1Jan)02 is a char 9 and not a date field. data comes back as jan,feb mar in order already.

Looking for simulor to the tab report
whats there now

01Apr02 jjjj xxxx nnnn

http://wwwww

aaaa zzzzz
01Aug02 jjjj xxxx nnnn

http://wwwww

aaaa zzzzz
01Dec02 jjjj xxxx nnnn

http://wwwww

aaaa zzzzz

what I'm looking for is to group by year 02

01Jan02 01Feb02 01Mar02
lables jjjj jjjj jjjj
nnnn nnnn nnnn

http://wwwww

http://wwwww

http://wwwww

aaaa aaaa aaaa
zzzzz zzzzz zzzzz

any ideas help

thanks dave

 

[synapsevampire]

I think that I addressed this in another post:

You have a few options here:

val(right(01 Jan 02,2))+2000 will return 2002, which is suitable for years beyond 1999, but I would suggest that you convert the text to a formula containing a date:


// @MyDate
cdate({MyTable.MyDateField})

Fortunately the cdate function appears to handle this format. If you experience problems, convert it into a format which can be used first (check help for cdate).

Now use this formula to group by (you can set groups on dates to be by the year using the The Section Will Be Printed set to for each year in the grouping dialog).

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com