Hello, all.
There’s a different report formula to display values set in a script. The
UserResponse function is reserved for the live inputs entered by a user. You
need to define your cell formulas as:
=ApplicationValue(“a. Start Date”)
=ApplicationValue(“b. End Date”)
But I would rather encourage you to use database date functions and date
objects to get the results you need, especially if you’re calculating start
dates and end dates for a set date (i.e. if it’s always “today”).
I’m not sure which database you’re using, but it’s not difficult with most
databases to get the month’s end date. You would define two objects, one
with a SQL equivalent of
GetMonthStartDate(sysdate), and
GetMonthEndDate(sysdate).
{These are not real function names, just examples. Check your database
syntax for proper formula}
You would then use these objects in your conditions against the desired
database date column(s).
Regards,
Luis Gonzalez
Listserv Archives (BOB member since 2002-06-25)