Page 1 of 1

Dates In Excel Report

PostPosted: Mon Jul 12, 2021 4:29 pm
I am trying to grab a field from all of a certain type of element and report it in Excel. The field on the element will always be a date. Once I have it in Excel I want to perform operations in separate cells based on the dates I am bringing in.

The problem I am having is that when I run my report and open it the dates are not able to be used for formulas. I have to click into each individual cell and back out before the date within it will be identified by a formula.

As a note that may help, when I first open up my report the dates are left aligned then once I click into the cell and back out it becomes right aligned and it suddenly can be used in formulas.

Is this something that has been seen before? Is there a solution from the report wizard side to have the cells be “initialized” immediately?