| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selecting todays date
Any way to rewrite the code below to choose whatever the current date
is instead of a specific date? =today(). ActiveSheet.PivotTables("PivotTable1").PivotFields ("DATE").CurrentPage = _ "12/22/08" I am trying to set up the sheet code to refresh the two pivot tables on the page and then change the dates to whatever the current date whenever the sheet is selected. thanx |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting todays date
This should give you the current date in your systems default format.
ActiveSheet.PivotTables("PivotTable1").PivotFields ("DATE"). _ CurrentPage = Date "J.W. Aldridge" wrote: Any way to rewrite the code below to choose whatever the current date is instead of a specific date? =today(). ActiveSheet.PivotTables("PivotTable1").PivotFields ("DATE").CurrentPage = _ "12/22/08" I am trying to set up the sheet code to refresh the two pivot tables on the page and then change the dates to whatever the current date whenever the sheet is selected. thanx |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting todays date
Thanx!
That works... One question though... How to change the format on that...? My current date format is ##-Mmm. The default is mm/dd/yyyy. Although the date populates in the pivot table field, it does not actually work because of the difference in format. Thanx again |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Selecting todays date
ActiveSheet.PivotTables("PivotTable1").PivotFields ("DATE").CurrentPage _
= format(Date,"dd-mmm") Is ##-Mmm the day number (2 digits) and the abbreviated month name? "J.W. Aldridge" wrote: Thanx! That works... One question though... How to change the format on that...? My current date format is ##-Mmm. The default is mm/dd/yyyy. Although the date populates in the pivot table field, it does not actually work because of the difference in format. Thanx again -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| is there a formula that will subtract todays date from a hire date | Excel Worksheet Functions | |||
| Selecting and keeping todays date | Excel Discussion (Misc queries) | |||
| Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
| Create a button that will date stamp todays date in a cell | Excel Discussion (Misc queries) | |||
| When I open my past invoice it keeps changing date to todays date | Excel Worksheet Functions | |||
Hybrid Mode
