-->
Sign in

ShoWorks Help Articles

Print This

Calculated Age shows up as a date format instead of number

ArticleID: 113033
Category: Reporting
Date Added: 9/17/2016

Problem:

Calculated Age (Exhbitor Calculated Age) shows up as a date format instead of number in reports.

Solution (Method A):

ShoWorks 2016 users need simply to download run the latest update and create a new or edit the report using the Report Wizard. See the updates here.

Solution (Method B):

If the report was created with the ShoWorks Report Wizard, edit the report (open the report, then click "Edit w/ShoWorks") and go to the step (click 'Next') that looks like the image below an place a check in the box "Hide Repeated Rows", then click "Finish".

Solution (Method C):

The following steps require the user to have the appropriate version of Microsoft Access installed on their machine which will allow the user to use the "ShoWorks Access Companion" icon. Please note that we do not provide technical assistance for Microsoft Access as this is out of the scope of our support. For more information about this feature, please see the following article: How to edit reports using Microsoft Access with the ShoWorks Companion

Steps:

  1. Exit ShoWorks.
  2. Open the ShoWorks Access Companion.
  3. Highlight the report and click "Edit w/Access".
  4. Click on the Text Box (not label) that contains "Exhibitor Age Calculated". Note, see the image below in that you should see the words "Text Box" in the highlighted area. The Text Box is usually below a similarly named label. Do not confuse the two.
  5. In the Properties window to the right (if not displayed, click the Properties button at the top right of the menubar), remove the word "Short Date" from the Format field.
  6. Close and save changes.



Question not answered in this article?
Click to Contact GladStone support for more information.

Login here with your
Service Plan Number

Need help in locating your Service Plan Number?