I would like select a date range (from/To) from a date database selection. The user enters a date (ProcessDate) in the database. ProcessDate is stored in table (tblData). I would like to get from another table (TblFund) the Rows that match the data criteria based on Date (ProcessDate)entered in the table (tblData).
Here is what I'm trying to do: I'm tryng to Select from tblfund, column fund_type where Column fund_type equals Car_Fund and the fundDate is between ProcessDate and EndDate. This selection is based on the date entered by the user which is the ProcessDate staored in another table. Code: dim dr as new DatabaseRecord dim Pdate as string dim EndDate as String dim sql as string // Pull the process date from the table, this is from date Pdate= "select ProcessDate from tblData" // this the last date of the criteria, the To date. Which is 6 months from the ProcessDate EndDate = Pdate '+6 months' sql = "SELECT * FROM tblFund WHERE UPPER(Fund_Type) = 'Car_FUND' AND FundDate = 'Issuedate' AND fundDate <= 'spendPeriod1'" -- View this message in context: http://old.nabble.com/Date-range-based-on-Date-in-different-table-tp29895994p29895994.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
