I want to create a formula which looks at todays date and the withdraws information based upon this.
Basically, I want to be able to calculate how many selling days have passed during the month, by looking at what todays date is.
I’ve already added in an excel file which contains a list of dates and how many selling days have passed on each date. And if I was to run a query such as:
= Where ( = 24/01/2007)
(Where Selling Days Gone and Date are columns in the excel file)
It works fine.
However, I want to be able to say:
= Where ( = )
(where current date is a formula, which withdraws todays date)
How do I do this? Is it a problem because there is a variable in the ‘Where’ statement? If so, How do you get around that.
Many thanks for any help at all and sorry if I didn’t put this post in the correct place…
Is this WebI or full client? What version? Let us know and we’ll move this to a more appropriate forum. Have you tried the If statement instead of Where…?
Thanks for moving this to the right place. I’ve had a look through the Reporter FAQ but I can’t find much there that will help.
I’ve already successfully created a variable which withdraws todays date, I just don’t know how to use this within a Where statement.