Hello Fullen,

You can find the number of days between two dates by subtracting them. For example:
Code:
=(TODAY()-DATE(2007,01,01))+1

gives the number of days YTD. There are a comprehensive list of date functions in the financial reporter (check the help). For example:
Code:
=(DATE(YEAR(TODAY()),MONTH(TODAY()),1)-TODAY())+1

will tell you the number of days that have elapsed in the current month. So would:
Code:
=DAY(TODAY())


You can use an ADGET() call to return the beginning ("gldates.START) and ending ("gldates.END") date of any specific period using the keys:
Code:
"C 1"  = Period 1
"C 2"  = Period 2
"C 3"  = Period 3
...
"C11"  = Period 11
"C12"  = Period 12
-or-
"P 1"  = Period 1 Last year
"P 2"  = Period 2 Last year
...
"P12"  = Period 12 last year.


You can add or subtract the dates returned by the ADGET function just as you can add or subtract a date returned by the DATE() or TODAY() functions.

OK?
_________________________
Andrew Bates