SwissMac General User

Joined: 20 Oct 2004 Posts: 45
|
Posted: Thu Feb 03, 2005 5:33 am Post subject: Use function variable outside of function? |
|
|
I have a function that creates a result that I wish to use outside of the function. How do I do this please?
The function works well and is used to identify the date of the last weekday of any particluar month (therefore avoiding weekend dates that will have no data) to use in a SELECT query to a MySQL database. After the date has been identified I want to use it to look up the appropriate data values and insert them into cells in a Calc spreadsheet. At the moment, although I get the correct date, it cannot be used outside of the function - what should I do to enable this, please?
I have had a look for Global variables and found some interesting links, but would appreciate some pointers and hints to make sure I am looking in the right direction.
TIA
Mac |
|