I have two fields in a journal, date1 and date2, which contain dates in the format YYYYMMDD. I want to calculate the number of days between the two dates and put the result it in a third field called days.
Any advice on how to do this would be greatly appreciated.