ok i am going nuts. I have a cell that i want to put the date into in excel. I am using Excel 2003 but can goto excell 2007 if needed.
Enter number of days to Query: (They enter 3)
Cell A2: I created a cell that is now()-3
Now i want the filter customers_info_0.customers_info_date_account_created to be >= A2 in workbook.
is there an easy way to do this?
SQL Query:
SELECT customers_info_0.customers_info_date_account_created, customers_0.customers_lastname, customers_0.customers_firstname, address_book_0.entry_street_address, address_book_0.entry_city, address_book_0.entry_state, countries_0.countries_name, address_book_0.entry_postcode, orders_0.cc_owner, orders_0.cc_number, orders_0.cc_expires, orders_0.cc_type
FROM inuitart.address_book address_book_0, inuitart.countries countries_0, inuitart.customers customers_0, inuitart.customers_info customers_info_0, inuitart.orders orders_0
WHERE orders_0.customers_id = customers_0.customers_id AND customers_info_0.customers_info_id = customers_0.customers_id AND address_book_0.customers_id = customers_0.customers_id AND countries_0.countries_id = address_book_0.entry_country_id
ORDER BY customers_info_0.customers_info_date_account_created DESC
Enter number of days to Query: (They enter 3)
Cell A2: I created a cell that is now()-3
Now i want the filter customers_info_0.customers_info_date_account_created to be >= A2 in workbook.
is there an easy way to do this?
SQL Query:
SELECT customers_info_0.customers_info_date_account_created, customers_0.customers_lastname, customers_0.customers_firstname, address_book_0.entry_street_address, address_book_0.entry_city, address_book_0.entry_state, countries_0.countries_name, address_book_0.entry_postcode, orders_0.cc_owner, orders_0.cc_number, orders_0.cc_expires, orders_0.cc_type
FROM inuitart.address_book address_book_0, inuitart.countries countries_0, inuitart.customers customers_0, inuitart.customers_info customers_info_0, inuitart.orders orders_0
WHERE orders_0.customers_id = customers_0.customers_id AND customers_info_0.customers_info_id = customers_0.customers_id AND address_book_0.customers_id = customers_0.customers_id AND countries_0.countries_id = address_book_0.entry_country_id
ORDER BY customers_info_0.customers_info_date_account_created DESC
Last edited: