Displaying function value on report

[hazelsisson]

Hi,

I have a report which asks the user for a parameter [Week Commencing].

The parameter is used both in the query and is displayed on the report.

I have a public function which returns a date value which is calculated from the parameter value. I'm trying to use this function in both the query and on the report, but I can't get it to work.

On the report I have a text box with this entered:

= financial_year([Week Commencing])

...but it just displays exactly that, rather than the function return value.

I've also tried formatting the parameter, e.g.

=financial_year(format([Week Commencing],"dd/mm/yy"))

and that doesn't work either.

It must be something simple but I can't find what I'm doing wrong!

Can anyone point me in the right direction?

Thanks,
Hazel

 

[GingerR]

are you sure it's in a text box and not a label?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[hazelsisson]

I'm so stupid!

Yes, that was the problem, thanks so much for your help GingerR!

(If it helps anyone - the function call with the date formatting didn't work, but was fine without).

 

[GingerR]

Hey--Not like I've never done THAT before!!

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244