Hi there,

What exactly are you trying to get to. The fiscal year and period are store in the GL transaction file, along with most of the other data from at AR/AP transaction. That would be a simple way to get to that.

If your fiscal calendar follows the natural calendar, then Lauren's approach works well.

If you fiscal calendar is 13 period or something odder, then I can send you a workspace that uses GETLINKEDVALUE() to get the year and period.

The next Upgrade to GridView includes functions to calculate this from a given date - but you'll have to wait for that a bit.