Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table & Dates
I have the following query in microsoft query,
SELECT v_AnalogHistory.DateTime, v_AnalogHistory.TagName, v_AnalogHistory.Value, v_AnalogHistory.wwRowCount FROM Runtime.dbo.v_AnalogHistory v_AnalogHistory WHERE (v_AnalogHistory.TagName='PS004_Pump1.Daily_Runtim e') AND (v_AnalogHistory.DateTime={ts '2007-01-01 00:00:00'} And v_AnalogHistory.DateTime<={ts '2007-01-14 23:59:59'}) OR (v_AnalogHistory.TagName='PS004_Pump2.Daily_Runtim e') OR (v_AnalogHistory.TagName='PS004_Pump1.Daily_Starts ') OR (v_AnalogHistory.TagName='PS004_Pump2.Daily_Starts ') what i would like to do is just grab the last 14 days of data..ie v_AnalogHistory.DateTime=GetDate() And v_AnalogHistory.DateTime<=GetDate()-14 is this possiable? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table & Dates
What is GetDate? Is that a function you have written? In any case what you
need to do is to write the SQL using the native SQL of the database you are connecting too. You can not use anything other than the native SQL commands. if it is just the last 14 days that should be fairly easy to do. -- HTH... Jim Thomlinson "Mark J" wrote: I have the following query in microsoft query, SELECT v_AnalogHistory.DateTime, v_AnalogHistory.TagName, v_AnalogHistory.Value, v_AnalogHistory.wwRowCount FROM Runtime.dbo.v_AnalogHistory v_AnalogHistory WHERE (v_AnalogHistory.TagName='PS004_Pump1.Daily_Runtim e') AND (v_AnalogHistory.DateTime={ts '2007-01-01 00:00:00'} And v_AnalogHistory.DateTime<={ts '2007-01-14 23:59:59'}) OR (v_AnalogHistory.TagName='PS004_Pump2.Daily_Runtim e') OR (v_AnalogHistory.TagName='PS004_Pump1.Daily_Starts ') OR (v_AnalogHistory.TagName='PS004_Pump2.Daily_Starts ') what i would like to do is just grab the last 14 days of data..ie v_AnalogHistory.DateTime=GetDate() And v_AnalogHistory.DateTime<=GetDate()-14 is this possiable? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Dates | Excel Discussion (Misc queries) | |||
dates on pivot table not right | Excel Discussion (Misc queries) | |||
Pivot Table and Pivot Table dates are not in correct order | Charts and Charting in Excel | |||
Dates in a pivot table | Excel Discussion (Misc queries) | |||
Pivot Table Dates | Excel Discussion (Misc queries) |