Date query help!!!

[dduvvuru]

Hi!
I am trying to extract calendar year from a term number.
Here is the example.


If the term number is 2096 - then the calendar year is 2008-09
If the term number is 2086- Then the calendar year is 2007-08

Right now I have the expression query built as
"200" & Mid ([Term],2,2)-1 & "-" & Mid([term],2,2)

So - if the term is 2096 it extracts 09 from the term and gives me 2008-09

The problem arised when the term number is 2116
Now using the above query, it calculates it as 20010-11 instead of 2010-11

Please direct me.

[weekend00]

I believe you can handle it using IF ... ELSE to deal with the years before and after 2010, but you just don't like an IF ...ELSE.

using complicate code is not a good pratice. it is usually much more different to understand, even for youself when you come back after a few months.


format(Mid(Term,2,2)-1,"2000") & "-" & Mid(term,2,2)

[dduvvuru]

Thank you so much. It works now.
Now that you mentioned about If and Else...Yes. I agree it is little bit more steps...but I guess anyone could easily understand if they read it.
Thanks once again.