I have a date field that I need to convert into a usable date format.
The current date is input into a field as yyyymmdd. But the number is
entered as text. Is there a way to format that number or a formula to use to
make that format usable? What I want to use the date for is to create a
formula that calculates the days past due. For example, =("invoice
date"+30)-today( ).
However the formula won't work with the date in its current format.