Skip to main content
Solved

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


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?

Best answer by lauraj46

Hi @aakoglu69 ,

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

Hope this helps!

Laura

View original
Did this topic help you find an answer to your question?

4 replies

dcomerford
Captain I
Forum|alt.badge.img+15
  • Captain I
  • 596 replies
  • April 9, 2024

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


  • Author
  • Freshman I
  • 4 replies
  • April 9, 2024

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
Captain II
Forum|alt.badge.img+8
  • Captain II
  • 511 replies
  • Answer
  • April 10, 2024

Hi @aakoglu69 ,

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

Hope this helps!

Laura


  • Author
  • Freshman I
  • 4 replies
  • April 10, 2024

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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings