Hi all,
I have a form with a date field/control that uses a formula to add months (12 or 18) based on two other fields. This field is not in the backend table. I created a query that includes it then made a report that pulls it in (and everything else) and displays them. Problem is, the calculated field works perfectly in the form but when I view it in the report it doesn't. I believe it's because the report (and thus the export to excel) it is not viewing one of the other date fields in the formula as a date. How do I get the report (and Excel) to view this as a date?
Sorry, I know this is long and confusing.