how can i display dates that are less than 1 week and equals to date now in mysql?

[jegar j]

select assignTitle,due Date from tblAssignment where dueDate=CONVERT (Date,GETDATE() ,113)

[India777]

Use >= and <= in where Condition

select assignTitle,due Date from tblAssignment where dueDate >=CONVERT(Date, dateadd(d,-7,GETDATE()),11 3) and <=Convert(Date, GetDate(),113);