Setting date and text based upon parameter selection

[mart10]

I am using CR 10

I want to produce wording as follows depending upon parameter i select (Interim or Annual)

If{?Period}="Interim" then "for the 6 months to X" else for the year to Y

X must allways be the end of June in the year i run the report and Y must allways be the end of year I run the report - and in this format: 30th June 2011

So if interim selection i should get:

for the 6 months to 30th June 2012 if i ran it next year for instance

 

[Turkbear]

Hi,
you could use a formula like:
@Mytext

If{?Period}="Interim" then "for the 6 months to 30th June" + ToText(Year(CurrentDate),"yyyy")
Else
"For the year to 31st December " + ToText(Year(CurrentDate),"yyyy")

To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[lbass]

Instead of:

ToText(Year(CurrentDate),"yyyy")

You would have to use:

ToText(CurrentDate,"yyyy")

or

ToText(Year(CurrentDate),"0000")

or

totext(year(currentdate),0,"")

...since year is a number. I've made this mistake myself.

-LB

 

[Turkbear]

Hi,
Good catch LB, thanks.





To Paraphrase:"The Help you get is proportional to the Help you give.."