Count the number of Working Weeks

[nofar]

Hi,

I am working on a new project now and I need some help. Here is the situation:
When we enter the serial number of a battery, we have to check if it will be rejected or not. For example if the serial number was SP044000056: the third digit is for the year this means that the batteries was manufactured in 2010 and on the 44th working week.
So the problem now is to calculate the number of week between the today's working week and the working week in which the battery was manufactured.

I am able to extract the working week of the battery which is 44 and the year which is 2010 with the function MID.

How can I continue?

Thanks

 

[John Big Booty]

Welcome to the forum.

Have a look at the various available date manipulation functions.

DateDiff() is probably part of what you are looking for.

 

[nofar]

I tried this function but it keeps giving me an error message I think because the fields are not dates fields. I attached my Database so you can see what I am talking about. In fact, In my query "Year and WW" i want to calculate the number of working weeks between the fields : Today WW and Battery WW

Thanks

 

[nofar]

here is my data base