I'm having some problems in the Financial Reporter since I installed the latest update today.

For example this
=STRCAT(TRIM(ADGETF("gldates.DESC",FPRIOR(0))))

used to give me a date. Now I get a blank line.

Please help - I have a board meeting next week...
Thanks.

Hello bal,

I cut and pasted the formula from your post into the financial reporter and it worked fine. Choose Edit | Company Profile | Fiscal Period Calendar and make sure that you have descriptions in all of your fiscal date entries. Alternatively, change the formula to either:
Code:

---

=ADGET("gldates.START",FPRIOR(0))
-or-
=ADGET("gldates.END",FPRIOR(0))

---

depending on whether you want to show the starting or ending date from the current period. You'll need to format the cell as a date, or use the value returned here in the =DATESTRING(date,format string) function to format the date the way you want. All the financial statements in the current sample data use formulas and date formatting rather than reading the description from the general ledger.

The latest release of Ledger (V8.0D) includes 2 new functions (=GLFPS() and =GLFPE()) that work in conjunction with a ".ColSpec" row to automatically pick up the starting and ending dates for the period selected. See the release note for details.

=ADGET("gldates.END",