Isolating the Unit value from then date

Hi all.
I’m looking to append the date with it’s suffix -2nd, 3rd, 21st etc - but don’t seem to be able to find out how to isolate the unit value. I was wanting to enter it into an opacity expression.

Anyone know how to do this??

1 Like

I did a search with 1st and this is one of the results .
.

.

1 Like

Oh wow! That’s a huge expression! I was hoping to have it simpler, but beggars can’t be choosers.
Thanks Russel.

1 Like

I don’t think the formula has to be so massive . It is only n1 n2 n3 that need a different appending . I think there are other solutions but sometimes the Long Hand is best these days .
You can isolate the Units of the date with

((#Dd#)%10)

So you will only need 4 conditionals .
Ist 2nd 3rd and the other th’s .

If you get stuck get back .

Ha Ha . When you try to shorten the formula you get to see the issues very quickly . Stick with the long hand .

Yes, K.I.S.S. is the easiest way, I just like brevity with code. Makes it easier to debug/alter

1 Like