AnsweredAssumed Answered

Extract number from field

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



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


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