By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,576 Members | 1,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,576 IT Pros & Developers. It's quick & easy.

define week 36 instead of 52

P: 2
Hi guys,

my department is using different Date system. If i give an example

"yyyyXX" these "yyyy" symbolized Years and XX weeks. but weeks are going max 36

what do i need :

normally : 2014/51, 2014/52, 2015/01 etc.

but with our system 2014/35, 2014/36 and 2015/01... its continue

i need to find difference these 2 numbers :
For example: 201436 - 201501 = 01

the question is : How can i define and chance these system according to my desire ?

Hope so you can help me

Ty for helps and understanding.
Mar 17 '15 #1
Share this Question
Share on Google+
3 Replies

Seth Schrock
Expert 2.5K+
P: 2,951
Are you saying that you want it to only have 36 weeks, or that the problem is that you are only getting 36 weeks?
Mar 17 '15 #2

Expert Mod 10K+
P: 12,430
It sounds like the issue isn't with the number of weeks. But with finding the difference between the 2 numbers.

If that's the case, you do it the same way you would with 52 weeks. Multiply the year by 52, add the weeks, do this for both numbers and subtract one from the other.
Mar 17 '15 #3

P: 2
Yes its difference between the 2 numbers. It looks like Modular arithmetic but it isnt. IŽll try with Excel if i could not do it in Access. Im not sure how shall i define. Everyone has different idea
Mar 18 '15 #4

Post your reply

Sign in to post your reply or Sign up for a free account.