A Balance Sheet column uses the BAL_Y spec, which reports the opening balance. But when I use this formula in the column heading:

GLFPE("BAL_Y","MMMM dd yyyy")

it prints January 31, 2012 instead of December 31, 2011

What formula should I use to get it to print December 31, 2011, no matter what fiscal period I select in the year 2012?

Thanks

Steve

'2012

BAL_Y = Open Balance This Year = Dates for FP 1

Maybe

BAL[12]M = Ending balance 12th fiscal period = Dates for FP12

is what you are looking for

BAL_Y = Open Balance This Year = Dates for FP 1

Maybe

[12]M = 12th fiscal period
is what you are looking for

BAL[12]M returns December 31, 2012. I want it to return December 31, 2011 no matter what period I select in FY 2012

Of course, this has to work for future years. I was only giving 2012/2011 as an example.

Steve

{1}BAL[12]M.

[12]M = 12th period for the current year
{1}[12]M = 12th period for the previous year

Thanks - both {1}BAL[12]M and {1}[12]M work.

This is a related question, although not about dates.

The client wants to see QTD figures for the current year and Quarterly figures for the 4 quarters of the prior year. When I use {1}[4]Q, instead of showing the 4th quarter figures for the prior year, it shows zero, unless I select period 12. But we are in period 2. I want it to show the total no matter what period I select.

What code do I use for that?

Thanks

Steve

Hi Steve,

What did the GL!SuperSpec form show as the expected code to use?