Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I enter a date range ie -7 from current date in MS QUERY
I am creating an excel pivot table using external data. I want to include
only records that are equal to current date and past 6 days. In otherwords, on any day that I run the pivot table I would bet current day + 6 days prior data. How would I setup the criteria and value cell. I can successfully specify a criteria field and in the value but = date(now()) and this works fine for current days data but I am having trouble using the date(now()) - 7. Any suggestions? Thanks |
#2
|
|||
|
|||
How do I enter a date range ie -7 from current date in MS QUERY
Hi
Personally, I would use Today() rather than Now(), unless you are sensitive to the hour as well. I your second criteria cell, are you using the = sign to show it is a formula i.e. =Today()-7. You don't need the Date() function at all =Today() =today()-7 Regards Roger Govier notsmartenough wrote: I am creating an excel pivot table using external data. I want to include only records that are equal to current date and past 6 days. In otherwords, on any day that I run the pivot table I would bet current day + 6 days prior data. How would I setup the criteria and value cell. I can successfully specify a criteria field and in the value but = date(now()) and this works fine for current days data but I am having trouble using the date(now()) - 7. Any suggestions? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
NETWORKDAYS - Multiple Date Selection | Excel Discussion (Misc queries) | |||
HOW DO I CHANGE QUERY DATA TO A DATE RANGE? | Excel Worksheet Functions | |||
HELP - Date Range In 1 Cell Calculation | Excel Worksheet Functions | |||
Excel Query Wizard Date Format | Excel Discussion (Misc queries) | |||
Automatically enter date and time but only update once. | New Users to Excel |