YYYYWW date format with criteria (1 Viewer)

Hi All,
First time posting but I would like to thank you for all the questions you have unknowingly answered.I am pretty new using access and these forms have been really helpful. I am having an issue that I can’t seem to find a solution to.

I am receiving some data that comes in with a date in text in the format of YYYY in column A and Week number in text in the format of WW in column B. I am trying to make a query that combines them into one column and something I can run some criteria against. For example, show me all for previous 4 weeks.

My attemptI am using the Expression Builder)

Field: DateAdd("ww",

2 options: Either make your data resolve to dates or build your own Date functions to compare your "dates".

1. Means you build a query on your table, bring in all its fields, then make a calculated field that is a date that reflects the first date of the week your Year and Week values represent. Then, you can build a query on top of that query to do your comparisons using the built-in Date functions.

2. Means you build your own function (e.g. WeeksDifference()) that takes your special "dates" and does the comparison for you and returns the value you need.

With all that said Week comparison is funky. You do know that every year spans at least 53 weeks right? (365 / 7 = 52 Remainder 1) . What happens with that 53rd week that doesn't have a full 7 days?

Without testing it, I think your problem is that the data for year and week is converted to text.
Either make it into number values or insert a 0 for all weeks between 1-9.
Ex: 20181 must be 201801 and 20182 = 201802.

Thank you both for your replies.
Plog, I think you are correct. What I ended up doing is converting the YearWK to a date then running my criteria against that. I know it’s a little funky to work in WK’s and doing it in access but it’s the best I have until I can get my data daily and move it into some reporting software.

Field: DateAdd("ww",((