Year separate digits

Hi

I’m trying to separate the year digits into 2 digits, “2” “0” instead of “20”

I tried several ways but no luck, any assistance is appreciated

Thanks
OZ

The easiest thing you can do (2020%2000)

Thank you @lucky.andrei, but it doesn’t work… I need to show “20” in 2 separate windows… “2” “0”

This is of course subject to certain restrictions on the year.

(floor((#Dyy#%100/10)))

(#Dyy#%10)

Thanks again @lucky.andrei… still doesn’t work…

I may have forgotten something for one formula (floor((#Dyy#%100/10))) :slightly_smiling_face:

Thank you very much @lucky.andrei

It is working now, and I also noticed a mistake from my side…

Much appreciated :pray:t4:

1 Like