Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Im making an applications with different tables with many data. Lets look at his example what causes the trouble (This is just an example, with dummy data to make the problem clear):
ID |
892018 |
902013 |
902102 |
902119 |
902240 |
912138 |
912148 |
912181 |
922151 |
922167 |
922213 |
922236 |
932172 |
932186 |
932208 |
932244 |
932251 |
932253 |
20041112 |
20041312 |
20052742 |
20054578 |
20137643 |
20134587 |
Each ID value contains the year of appeal. The problem is that before the year 2000 the ID's contains a year of 2 numbers like 90, 91, 92 etc. How can i get a year column out of these ID's?
If(Len(ID)=6, 19 & Left(ID, 2), Left(ID, 4)) as Year
If(Len(ID)=6, 19 & Left(ID, 2), Left(ID, 4)) as Year
That should work!!
Hi
If my understanding is correct last 4 chars are ID then you can use 'Right' function.
Regards
Mallik
It worked, thanks!
Correct !!