Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table + Microsoft Query + Current Month
I automate most of my reports using pivot tabes... I use multiple criteria in
the backend such as =date() -1, like f*, etc... Anyways, is there a function I can place in crerita to give me current month... I would like to make my pivots a bit more dynamic.. Source data is either SQL Server 2005 or Access Databases... I know I can do it on database end when creating the views/queries however I would like to see if I can do it at the Excel end as well.. I appreciate the help Ramon |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pivot Table + Microsoft Query + Current Month
Hi,
That depends on how your months are stored: You could use =MONTH(TODAY()) this gets you the month number of the current month You could use EOMONTH(TODAY(),-1) and <=EOMONTH(TODAY(),0) this function is part of the analysis toolpak. Or you could use =DATE(YEAR(TODAY()),MONTH(TODAY()),1) and <=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1 If this helps please click the Yes button. -- Thanks, Shane Devenshire "THE_RAMONES" wrote: I automate most of my reports using pivot tabes... I use multiple criteria in the backend such as =date() -1, like f*, etc... Anyways, is there a function I can place in crerita to give me current month... I would like to make my pivots a bit more dynamic.. Source data is either SQL Server 2005 or Access Databases... I know I can do it on database end when creating the views/queries however I would like to see if I can do it at the Excel end as well.. I appreciate the help Ramon |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Microsoft Query & Pivot table? | Excel Discussion (Misc queries) | |||
Selecting the current month using a macro on a pivot table | Excel Discussion (Misc queries) | |||
Creating Date Range in Pivot Microsoft Query | Excel Discussion (Misc queries) | |||
Current Month Query | Excel Worksheet Functions | |||
Using Microsoft Query data in a pivot table. | Charts and Charting in Excel |