Dates In Excel Report

Uploaded report templates and discussions about reports.

Moderators: sarawut_w, Moderators

Dates In Excel Report

Postby robert.n.kellogg@aero.org » 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?
robert.n.kellogg@aero.org
Forum Newbie
Forum Newbie
 
Posts: 1
Posts Rating:0
Joined: Mon Jul 12, 2021 1:37 pm

Return to Report Engine

Who is online

Users browsing this forum: No registered users and 2 guests