Solved

Conversion failed when converting date and/or time from character string

  • 8 April 2024
  • 4 replies
  • 33 views
A
Rank

I am trying to create a filter for my Dashboard KPI, but receiving the ‘ Conversion failed when converting date and/or time from character string’ error. Not really sure why as the parameter I am using in the filter should not be a string (see attached). What am I doing wrong?

icon

Best answer by lauraj46 10 April 2024, 18:07

View original
1 Attachment

4 replies

dcomerford
Rank
Userlevel 7
Badge +12

Try enclosing the calculation in CDate so in value1 put CDATE(DateAdd (Today(), ‘m’ ,-3))

Dermot Comerford
A
Rank

Thank you for the quick reply. Unfortunately, it didn’t work. I get the same error.

I have also tried replacing TODAY() with @DATE or @MonthStart and still didn’t work

lauraj46
Rank
Userlevel 7
Badge +7

Hi @aakoglu69 ,

For GI and Dashboard filters, I believe the syntax is: @Today - 3

Hope this helps!

Laura

Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
A
Rank

Thank you so much. Yes, that did it. Changed 3 to 90 for 3 months and boom 😁

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved