Hello msequin,

Have the dates been entered as text on the sheet?

Instead of text, you should create formulas so that the dates change as the Fiscal periods change.

There are several examples in sample data. Look for GL!DateFunctionExamples.sam. The page for Insert Formula Fields has some examples. You should also look at the ColSpec Functions page. It has examples for the formulas to extract the starting and ending fiscal periods: =GLFPS and =GLFPE
_________________________
Regards,
Softrak Tech Support