sql - how to get records who is reaching todays date -
i want records reach todays date in 2 days projectenddt. want show projects going end in 2 days. want show 2 days before.
query
select projectenddt        , projectrenewaldt         , projectupgradedt   tbl_project  convert(varchar(10), dateadd(day, 2, projectenddt)) >= convert(varchar(10), getdate());  
Comments
Post a Comment