I am tring to create a query that searches for records where the week number that record was created is the same as the current date week number.
My plan was to have a field in the record for week number and then use that as my query criteria. Are there any functions that get the value of the current week that i can use in my create record query?
Im using SQL and VB6 studios. Please help