Convert/Action: YEAR Convert

[dec]

ok, guys, why is this argument not working, but returns NULL

$cutRight(%year%,$len(%year%)-4)

[ohrenkino]

to subtract 2 values you have to use the function $sub()
$cutRight(%year%,$sub($len(%year%),4))
Unfortunately, you do not supply the real source data - in cases where year looks like 2023-04-10 this works also:
$num(%year%,1)

[dec]

@ohrenkino

$num(%year%,1)

hmm. thanks

i tried $num and it worked fine on a typical example; but i should have sorted the list by Year to check for atypical/different values/formats, because i now i have a lot of blank and '0000' Year fields (butr most are ok).