AugForums.com

An Acumatica User Group

  • Free
    • Start Here
    • In-Person Gatherings
    • Power BI Workshop
    • Podcast
    • Rolodex
    • Blog
    • Forums
  • Paid
    • AugSQL
    • GI Course
    • GI Library
    • Consulting
  • Register

— The Forums are now read-only —

— All new activity now takes place here: —

AugForums.com Discord Server
Forums
AUG Forums
Acumatica Dashboard...
Conversion failed w...
 
Notifications
Clear all

Questions Conversion failed when converting date and/or time from character string on Acumatica Dashboard

 
Acumatica Dashboards
Last Post by Tim Rodman 4 years ago
2 Posts
2 Users
0 Reactions
2,120 Views
RSS
mlaraiv
Posts: 5
 mlaraiv
Topic starter
January 13, 2022 4:42 pm
(@mlaraiv)
Active Member
Joined: 5 years ago

I have an issue on my dashboard where creating a KPI scorecard gives me the following error: “Conversion failed when converting date and/or time from character string”. 

My GI’s work perfectly on the dashboard when in data table format, and even in the GI itself I am able to aggregate the column on the bottom of the screen without issue. For some reason when I create the scorecard, I receive this error. Anyone seen this before? (attached XML for the GI in question)

Sales By Customer (1).xml

 


1 Reply
Tim Rodman
Posts: 3204
 Tim Rodman
Admin
February 18, 2022 10:30 am
(@timrodman)
Famed Member
Joined: 11 years ago

Go to TOOLS -> Trace... and look for the SQL code that the Dashboard is running. That can usually give you a clue as to why it's returning an error.


Reply
Forum Jump:
  Previous Topic
Next Topic  
Forum Information
Recent Posts
Unread Posts
Tags
  • 12 Forums
  • 2,533 Topics
  • 11 K Posts
  • 17 Online
  • 2,437 Members
Our newest member: Matt Butler
Latest Post: Nested SubReport Issue
Forum Icons: Forum contains no unread posts Forum contains unread posts
Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed

By using this website, you agree to our Terms of Use (click here)

Acumatica Forums

Terms of Use & Disclaimers :: Privacy Policy

Copyright © · AUG Forums, LLC. All rights reserved. This website is not owned, affiliated with, or endorsed by Acumatica, Inc.

‹›×

    ‹›×