jazminecat
Programmer
Hi all -
I have a table with dates in mm/dd/yy format. I need to write a query to find all records with a date during the current week. I can find all records for today using
Date() or Now()
but can't find a similar function to find all records for the current week. I need to be able to run this on any day of the week.
thanks!
I have a table with dates in mm/dd/yy format. I need to write a query to find all records with a date during the current week. I can find all records for today using
Date() or Now()
but can't find a similar function to find all records for the current week. I need to be able to run this on any day of the week.
thanks!