how to add 7 days to my date filter
Database
3
Posts
3
Posters
0
Views
1
Watching
-
how to add 7 days to my date filter i want to add 7 days to date the user will select select employee_Id from attendance where [date]='2005-01-10' + 07
Ahmed hassan
Are you using SQL Server? If so, look at DateAdd.
Deja View - the feeling that you've seen this post before.
-
how to add 7 days to my date filter i want to add 7 days to date the user will select select employee_Id from attendance where [date]='2005-01-10' + 07
Ahmed hassan
try with following Query select employee_Id from attendance where [date]= dateadd(day,7,'2005-01-10')
smile :-)