on 05-31-2011 6:50 AM
Hi,
I am using xcelsius 2008, i have developed a report and it should run on a particular date (current date) without hard coding it in the worksheet. because don't want the user to enter date , and report should run for current date.
Regards
Aflal
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
you can insert a excel formula: =today(), and pass it to your query
Thx, Hao
Dear Hao,
If we want to give a date range what should we do
Still, you would use Excel formulas. I assume you're passing values to a filter? E.g.
From date: =now()-365
To date: =now()
Or something to that effect.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.