CR XI - Help Pls...

[OrionStar]

What is wrong with this formula???

if({BKCYACCT.File Open Date})< date(2005,01,01) then "Prev.Date"
else {BKCYACCT.File Open Date}



BKCYACCT.File Open Date IS A date FORMAT...

The error is highlighting the last {BKCYACCT.File Open Date} and saying ....a string is required here.

Am I missing something???

Thanks:

MV

"What would you attempt to do... if you knew ... you could not fail?

 

[kskid]

Since "Prev.date" is a string, then {BKCYACCT.File Open Date} must be converted to a string.

if({BKCYACCT.File Open Date})< date(2005,01,01) then "Prev.Date"
else totext({BKCYACCT.File Open Date},"MM/dd/yyyy")

-lw

 

[OrionStar]

More help please. I have a cross tab that I want to use this field as a column and group by MONTH. So that PrevDate is a column, then 01/05, 02/05, 03/05 ETC..ETC.

I don't get the DATE grouping option if this field is a STRING OR A NUMBER////????

How can I get ONE grouping for ALL DATES prior to 01/01/05 and THEN... a column for each month in 2005???

THANKS

Thanks:

MV

"What would you attempt to do... if you knew ... you could not fail?

 

[kskid]

You could

1. Change your group and select specified order and place all dates < 2005 in Others

or

2. Change the formula to assign a previous date

if({BKCYACCT.File Open Date})< date(2005,01,01) then date(2004,12,31)
else {BKCYACCT.File Open Date}

 

[Crystalyzer]

I am using CR XI and I am having difficulty with date parameters. I cant seem to get it to default to today. The parameter field force the use of the date picker to enter a value. This is really cumbersome, especially for reports that are often run as of the current date, however need the capacity to be run as of some other date.

Can anyone help?

thanks

Thanks and best regards,
-Lloyd