I have a String field 'INTERVAL' giving the two dates used for a difference image in the form "YYYYMMDD_YYYYMMDD". I would like to populate a second field 'MONTH' giving the month of the median date of the two dates in 'INTERVAL' i.e. date1 + (date2 - date1 / 2) for example for 'INTERVAL' = 20180325_20180420 , the median month would be 4.
Ideally prefer to do it with Calculate Value in Modelbuilder.
I am not Python savvy so dealing with dates is particularly vexing.