I have 2 fields that are Dec 8,0 and they represent a date in YYYYMMDD. I want to subtract one from the other, always knowing that the first date is greater than the second. the dates represent when something got recieved (podt00) minus when it shipped (rddt00) to get a number of days result.
I am trying this:
DAYs(date(podt00)) - DAYs(date(rddt00))