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?
Answer
Conversion failed when converting date and/or time from character string
Best answer by lauraj46
Hi
For GI and Dashboard filters, I believe the syntax is: @Today - 3
Hope this helps!
Laura
+15Try enclosing the calculation in CDate so in value1 put CDATE(DateAdd (Today(), ‘m’ ,-3))
Dermot Comerford
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
+8Hi
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*.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.