Grouping with A formula issue

[Former Member]

I am grouping on a date that was calculated using the following formula :

local stringvar d:= {TAGDTL.USER_DEF_TEXT_1}; //or database field

numbervar y:= tonumber ( '20' & d[5 to 6]);

numbervar m:= tonumber ( d[1 to 2] );

numbervar dd:= tonumber ( d[3to 4] );

date( y, m, dd)

The date displays fine, however when I group on it, it appears that it ignores the date completely.

The data in the detail shows up

10/14/2008

10/15/2008

10/16/2008 etc

however the group shows up with a completly different date.

Group = 10/12/2008

detail = 10/14/2008

detail = 10/15/2008 etc....

any ideas? Suggestions? help?

Thanks,

Jim

[Former Member · Accepted solution]

Sorry guys, still get the same results...... I have tried the formula

Whilereadingrecords;

numbervar y:= tonumber("20" & Mid ({TAGDTL.USER_DEF_TEXT_1},5,2)); numbervar m:= tonumber(Mid ({TAGDTL.USER_DEF_TEXT_1},1,2)); numbervar dd:= tonumber(Mid ({TAGDTL.USER_DEF_TEXT_1},3,2));

cdate( y, m, dd);

and still get the same results...

this is all done in a formula correct?

Edited by: James Fulton on Oct 20, 2008 7:06 PM

[Former Member · Accepted solution]

Hi James,

Yes,. you will have to create a formula and insert the same in your report. I believe you are not using your database field in your report in any of your sections.

You can check by placing your database field and formula side by side in your report.

Do you have multiple groups in your report ?

Thanks,

Sastry

[Former Member]

Hi James,

I think you have to use Evaluation Function before creating the formula like this

whilereadingrecords;
stringvar d:= {TAGDTL.USER_DEF_TEXT_1}; 
numbervar y:= tonumber ( '20' & d[5 to 6]);
numbervar m:= tonumber ( d[1 to 2] );
numbervar dd:= tonumber ( d[3 to 4] );

date( y, m, dd)

Hope this Helps!

Raghavendra

[Former Member]

Hi James,

Try to insert the following in a formula and place this on your detail section also insert as a gourp.

numbervar y:= tonumber("20" & Mid ({TAGDTL.USER_DEF_TEXT_1},5,2));

numbervar m:= tonumber(Mid ({TAGDTL.USER_DEF_TEXT_1},1,2));

numbervar dd:= tonumber(Mid ({TAGDTL.USER_DEF_TEXT_1},3,2));

cdate( y, m, dd);

Thanks,

Sastry