how do I display the month name e.g June
Hi
I have this in a memo, "Sales for [MonthOf(<frxDBDataset2."Date">)]" (without quotes). This of course displays "Sales for 8" if the month (of the supplied date) is August.
What is the best or preferred method to have a "function" like this that will print Sales for August (if the month number is 8)?
I tried creating a variable category of Months and entered the month names as variables in the Months category, i.e January, February...... December, hoping that I could do something like Months[ [MonthOf(<frxDBDataset2."Date">)]]. I tried this with a hard coded value (e.g. Months[8] ) to test it but could not get it to work. Am I on the right track, or is there a completely different method.
Thank you...
Kind regards
Peter
I have this in a memo, "Sales for [MonthOf(<frxDBDataset2."Date">)]" (without quotes). This of course displays "Sales for 8" if the month (of the supplied date) is August.
What is the best or preferred method to have a "function" like this that will print Sales for August (if the month number is 8)?
I tried creating a variable category of Months and entered the month names as variables in the Months category, i.e January, February...... December, hoping that I could do something like Months[ [MonthOf(<frxDBDataset2."Date">)]]. I tried this with a hard coded value (e.g. Months[8] ) to test it but could not get it to work. Am I on the right track, or is there a completely different method.
Thank you...
Kind regards
Peter
Comments
see the code in the main demo calendar report or the expressions in the cross crosstab report.
Thank you, I have it working now [img]style_emoticons/<#EMO_DIR#>/smile.gif" style="vertical-align:middle" emoid=":)" border="0" alt="smile.gif" /> Kind regards Peter[/img]