how to select oly future records with respectto present date

Question

hi i saved future records in the sql table using insert query for every present day...bcoz i can able to fill only future date records.that is the condition.due to dat i want to see future saved records from SQL table from every present day.. ex: tdy may 18th... i can view only May 20th-June 20th records... and tmrw may 19th ... i can view only May 21th - June 21th records... it ll automatically increment... show the output in the Grid view with respect to the present day... can any1 help how to write sql query with respect get records every present day..... sql query with select future date with respect to present date..

Amit Gupta · Answer

Hi I cannot understand your question properly. Suppose today date is 18/05/2016 and you want to show recorda greater than 18th Assuming fdate is column Rtab is tablename Query: Select * from Rtab where fdate> getdate () // you can write +1 after getdate () to increase the day by 1. If you want records between dates for a month Query: Select * from Rtab where fdate between gatedate () and dateadd (m1 getdate()) ... where m stands for month .. ....1 will be increment in current month. Hope it helps

Ravi Sangtani · Answer

Hi Kamala Veni This is the Query You want : Here t_date is field name of date field and tbl_demo is table name. select t_date from tbl_demo where datediff(d getdate() t_date) = 1 or datediff(d getdate() t_date) = 2 Accept answer if i solve your problem... Thank You

Kamala Veni · Answer

hi.. Thank u Amit ji for the reply... Its wrks fr every next month with respect to present day? can u explain with any example...

Amit Gupta · Answer

Hi Kamala You can run sql query as under Select * from tablename where futuredate> getdate () You can get all respective records which is having future date only. Accept the answer if found useful