how to select oly future records with respectto present date

Kamala Veni

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..

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Gupta10y ago
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 (m,1, getdate())

... where m stands for month ..
....1 will be increment in current month.

Hope it helps
Ravi Sangtani10y ago
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 Veni10y ago
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 Gupta10y ago
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