Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[risingdamp]

I have a custom field called Decade and I want to write a DB expression that will tell me if the decade is wrong based on the value of Date(year).  It will simply establish if the first character of Decade is the same as the third character of Date(year) e.g.:

Decade = 60s
Date(year) = 1965

...would be OK and this would not be OK

Decade = 80s
Date(year) = 1995

I feel this could be done with a combination of FormatBoolean, IsEqual and Mid but there's just too much nesting for me to work it out.  Can someone help?

[risingdamp]

Well I managed it eventually 

Code: [Select]

If(IsEqual(Mid([Decade],0,1),Mid([Date (Year)],2,1),1),Decade Ok,Decade Wrong)
Of course this won't work where the decade should be 2000+ where the Date (Year) begins with a 2 so I just need a separate VS for that.