I have a report that has two extract formulas. The first one is extract(MONTH,[Invoice Date]) and the second one is extract(YEAR,[Ship Date]). They work great. What I want to do now is combine them so I get the result of 10/2007. Any suggestions on what the syntax should be to accomplish this? Thanks in advance for any suggestions.
Hi,
If you just need this value displaying (rather than for filtering or use in further calculations etc), then you don't need to combine them. Unlock your report structure and drag your month calculation, a text item containing '/' and your year calculation all into the same cell.
Regards,
MF.