Skip to main content

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?

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

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

Hi @aakoglu69 ,

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

Hope this helps!

Laura

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