Link to home
Start Free TrialLog in
Avatar of PeterErhard
PeterErhard

asked on

Show Records where Start Date is 2 days before starts

I have a record in a database table named "CompetitionStartDate".

I want to show all records in the table where the CompetitionStartDate is only 2 days in the future from today.

How could this be done?
Avatar of arnold
arnold
Flag of United States of America image

select * from table where datediff(day,getdate(),competitionstartdate) between 0 and 2
Avatar of PeterErhard
PeterErhard

ASKER

#1305 - FUNCTION getdate does not exist
ASKER CERTIFIED SOLUTION
Avatar of arnold
arnold
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial