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

Comments

  • gordkgordk St.Catherines On. Canada.
    edited 4:15AM
    set up an array 1.. 12 string of month names in the report script.
    see the code in the main demo calendar report or the expressions in the cross crosstab report.
  • Hi
    gordk wrote: »
    set up an array 1.. 12 string of month names in the report script.
    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]

Leave a Comment

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.