Hello all, Please assist with the following problem:
I have a table field named: "Date". I would like to create a query with a calculated field named "Week" that will read the Date value in the table field "Date" and return:
1 if the date falls in the first week of the respective month
2 if the date falls in the second week of the respective month
3 if the date falls in the third week of the respective month
4 if the date falls in the fourth week of the respective month
Please assist me with this. Thank you.