Convert/Action: YEAR Convert

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


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

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).

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.