AnsweredAssumed Answered

Extract number from field

Question asked by AlexOrrow on Sep 11, 2018
Latest reply on Sep 11, 2018 by philmodjunk

Hi,

 

I have a field with an auto enter calculation returning the creation date and time of an image as Text.

e.g.

"23/08/2018 10:17:56"

 

I'd like to extract only the year from this. I have managed to get the day and month extracted separately but I am stumped on the correct calculation to extract only the year. Any help much appreciated, thank you.

Outcomes